Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Font Color
I have a dollar value in cell A2. I would like the font color to change to
RED when the value in cell A2 is equal to, or less than, 25% of the dollar value in cell A3. Is there an easy way to do this in Conditional Formating? Any help appreciated, Pete |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Font Color
Hi
Select cell A2, click on Format, Conditional Formatting. Change Cell Value is to Formula Is, and enter the following formula =A2<=A3*.25 Click on Format, select Font, change Font Color to red -- HTH Kassie Replace xxx with hotmail "Pete" wrote: I have a dollar value in cell A2. I would like the font color to change to RED when the value in cell A2 is equal to, or less than, 25% of the dollar value in cell A3. Is there an easy way to do this in Conditional Formating? Any help appreciated, Pete |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Font Color
Kassie,
Thanks - that works perfectly Pete "Kassie" wrote: Hi Select cell A2, click on Format, Conditional Formatting. Change Cell Value is to Formula Is, and enter the following formula =A2<=A3*.25 Click on Format, select Font, change Font Color to red -- HTH Kassie Replace xxx with hotmail "Pete" wrote: I have a dollar value in cell A2. I would like the font color to change to RED when the value in cell A2 is equal to, or less than, 25% of the dollar value in cell A3. Is there an easy way to do this in Conditional Formating? Any help appreciated, Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Checkbox to change background color, font color and remove/ add bo | Excel Discussion (Misc queries) | |||
Conditional Format for font color using font color | Excel Worksheet Functions | |||
Changing Font color based on font type or size | Excel Discussion (Misc queries) | |||
Check Font or Font color and take action | Excel Programming | |||
My fill color and font color do not work in Excel Std Edition 2003 | Excel Discussion (Misc queries) |