change colour of font when below 94% automatically
 

automatically change font colour if below a certain percentage.

change colour of font when below 94% automatically
 

Set conditional formatting for this cell when it is "less than .94"


"confused" wrote in message
...
automatically change font colour if below a certain percentage.

change colour of font when below 94% automatically
 

Select your cell(s) then

Format|Conditional format
Cell value is - Less then - enter the desired precentage
Click Format
select Font
Select a colour
Click OK

Mike


"confused" wrote:

automatically change font colour if below a certain percentage.