Different Font Color for results evaluated by "IF"

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

exceltyro - 05 Apr 2007 22:54 GMT

How to print the evaluated results from an "IF"
function in different font colors for the two choices??

Reply to this Message

Peo Sjoblom - 05 Apr 2007 23:28 GMT

You can apply format > conditional formatting, select cell value equal to
the first "choice", format the font to your liking, then add a second
condition and repeat but use the second "choice" and another font colour

Signature

Regards,

Peo Sjoblom

> How to print the evaluated results from an "IF"
> function in different font colors for the two choices??

Reply to this Message

exceltyro - 09 Apr 2007 17:38 GMT

Thanks Peo.

> You can apply format > conditional formatting, select cell value equal to
> the first "choice", format the font to your liking, then add a second
> condition and repeat but use the second "choice" and another font colour
>
> > How to print the evaluated results from an "IF"
> > function in different font colors for the two choices??

Reply to this Message