Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
automatic font color
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
automatic font color
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
automatic font color
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic Font Color | Excel Worksheet Functions | |||
Changing Font color based on font type or size | Excel Discussion (Misc queries) | |||
How do I change the AUTOMATIC color in Excel for the font? | Excel Discussion (Misc queries) | |||
Default Border, Font Color, and Cell Background Color | Excel Discussion (Misc queries) | |||
My fill color and font color do not work in Excel Std Edition 2003 | Excel Discussion (Misc queries) |