Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Select D4 then go to
FormatConditional FormattingFormula is: =C4<0 Format the Font to your red color. Gord Dibben MS Excel MVP On Thu, 17 May 2007 08:17:02 -0700, Jamie wrote: How can I make a cell value be a different font colors based on the value of another cell? ex: If the value of C4 is negative, then the value in D4 will be in red. (Needs to be red font not highlighting) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
font colors | Excel Discussion (Misc queries) | |||
Changing font colors... | New Users to Excel | |||
Font Colors | Setting up and Configuration of Excel | |||
changing colors of font in functions | Excel Worksheet Functions | |||
Can't format font colors or cell fill-in colors | Excel Discussion (Misc queries) |