IF Formula that would Format Font Color

D

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
 
J

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
 
G

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
 
D

DwightM

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

Allan S. Warrior

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

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
 
Top