Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Does anyone know the expression to format text, say in cell A5, to blue if
the value of cell A4=0 and to red if the value of cell A4<0? I know how to do conditional formatting on cell A4, based on the value of cell A4, but how do you format one cell based on the value of another? Thanks in advance for your help! Liz |
#2
![]() |
|||
|
|||
![]()
You're on your way. Just use the "formula is.." option in conditional
formatting of A5 and plug in =A4<0, choose color, then A4=0 and choose color. "Liz C" wrote in message ... Does anyone know the expression to format text, say in cell A5, to blue if the value of cell A4=0 and to red if the value of cell A4<0? I know how to do conditional formatting on cell A4, based on the value of cell A4, but how do you format one cell based on the value of another? Thanks in advance for your help! Liz |
#3
![]() |
|||
|
|||
![]()
Great! Thanks, Dave!
"Dave R." wrote: You're on your way. Just use the "formula is.." option in conditional formatting of A5 and plug in =A4<0, choose color, then A4=0 and choose color. "Liz C" wrote in message ... Does anyone know the expression to format text, say in cell A5, to blue if the value of cell A4=0 and to red if the value of cell A4<0? I know how to do conditional formatting on cell A4, based on the value of cell A4, but how do you format one cell based on the value of another? Thanks in advance for your help! Liz |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Format cell in column B based on value in the next cell (column c) | Excel Discussion (Misc queries) | |||
Custom format a text cell with square brackets: [ ] ? | Excel Discussion (Misc queries) | |||
How do I create a bulleted list text format inside cell? | Excel Discussion (Misc queries) | |||
Format text based on which of several unique lists the value belongs to? | Excel Worksheet Functions |