using the IF function to automatically change the color of the fon

M

Max1103

Let say i want to set up a scenerio that says if A12 is less then 60% change
font to red.

I am not sure how to go about doing this. I understand IF formulas but not
advanced.
 
F

FSt1

hi
formula can't do this but conditional formating can.
on the menu bar...
format>conditional format....
cell value is > less than > .6 > pick your format.

regards
FSt1
 
J

Jim Thomlinson

Select Cell A12. From the xl menu choose Format -> Conditional Format.
In the dialog that opens choose Cell value is less than 0.6
Change the format to a red font.
 
M

Max1103

Thank you so much. I really appreciate that

FSt1 said:
hi
formula can't do this but conditional formating can.
on the menu bar...
format>conditional format....
cell value is > less than > .6 > pick your format.

regards
FSt1
Click to expand...
 
Top