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

regards
FSt1



"Max1103" wrote:

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.