change colour of font when below 94% automatically

[confused]

automatically change font colour if below a certain percentage.

 

[Castell]

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

 

[Mike H]

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