Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula needed changing font color
I'm trying to write a formula for my spreadsheet that has the
following logic: If current value (column G) is greater than value located in (column D), then change the font color to green. If not greater, then change the font to red. For example, Cell G4 has a value higher than D4, so I'd want it green. Cell G5 has a value less than D5, so I'd want it red. Any ideas? Thanks in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula needed changing font color
Take a look at Format|Conditional formatting.
(You can't change the font color using formulas in your cells.) John wrote: I'm trying to write a formula for my spreadsheet that has the following logic: If current value (column G) is greater than value located in (column D), then change the font color to green. If not greater, then change the font to red. For example, Cell G4 has a value higher than D4, so I'd want it green. Cell G5 has a value less than D5, so I'd want it red. Any ideas? Thanks in advance. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Font color changing by itself | Excel Discussion (Misc queries) | |||
Changing Font color based on font type or size | Excel Discussion (Misc queries) | |||
Changing Font Color | Excel Discussion (Misc queries) | |||
Changing the font color using VBA | Excel Programming | |||
Changing Font Color | Excel Programming |