IF Formula that would Format Font Color

[DwightM]

Hello All,

I am setting up a spreadsheet that I would like to format a I
formula that would change the color of the font to red.
For example =IF(B2>100 change font to red

Thank you
-Dwigh

 

[Jason Morin]

One way is via custom formatting. Click B2, press Ctrl+1,
click the Number tab, click Custom, and insert:

[Red][>100]General;General

HTH
Jason
Atlanta, GA

 

[Gord Dibben]

Dwight

Check out the options in Format>Conditional Formatting.

Select B2 then Format>CF>cell value is: greater than 100

Pick a color from the Format button then OK your way out.

Gord Dibben Excel MVP

 

[DwightM]

This is almost working. The 100 is a % format and it is not working.
Any more suggestions

 

[Guest]

For the value to compare against using the Conditional Formatting, be sure to
type 100% or 1.0.

 

[DwightM]

I have modified the format to read [Red][>100]0%;0% . Now the problem i
that it does not change colors when the item is over 100%. TO test th
format I changed it to "<" instead of ">" and when I do that all th
number change to Red. I need help..

Thank you

-Dwigh

 

[DwightM]

Thank you this worked I appreciate it

 

[DwightM]

--