Thank you so much for the quick response! Even though I have Excel 2007, I
was able to figure it out with this web site. Thanks again.
"Jacob Skaria" wrote:
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.