Refer the link

http://www.contextures.com/xlCondFormat01.html
condition is cell value less than .98

If you are using a formula
=A1<0.98

If this post helps click Yes
---------------
Jacob Skaria


"LeAnne" wrote:

I have a spreadsheet where I keep track of scores that are in the form of
percentages. If the score is below 98% I want the font to be red. Is there
a way to format the column to automatically show scores below 98% in red font
and above 98% in black font? Thanks.