| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Font color change if cell if null
I want to make a conditional format where cell 2E returns a red font color if
cell 2P has nothing entered, and returns black font color if there is a value in 2P. I can't figure out how to do this. Please help |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Font color change if cell if null
Hi,
use conditional formating in E2, using where the formula is, enter =P2="" then choose red color to fill the cell on the other case =P2<"" choose black color if this helps please click yes "asljwgirl" wrote: I want to make a conditional format where cell 2E returns a red font color if cell 2P has nothing entered, and returns black font color if there is a value in 2P. I can't figure out how to do this. Please help |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Font color change if cell if null
Thank you this worked perfectly
"Eduardo" wrote: Hi, use conditional formating in E2, using where the formula is, enter =P2="" then choose red color to fill the cell on the other case =P2<"" choose black color if this helps please click yes "asljwgirl" wrote: I want to make a conditional format where cell 2E returns a red font color if cell 2P has nothing entered, and returns black font color if there is a value in 2P. I can't figure out how to do this. Please help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cannot change font color or cell color | Excel Discussion (Misc queries) | |||
| Reg. Change of font color in a cell | Excel Worksheet Functions | |||
| Change font color in cell | Excel Discussion (Misc queries) | |||
| Change font/cell color by Formula | Excel Worksheet Functions | |||
| How to change the default Border, Font Color, and Cell Color | Excel Discussion (Misc queries) | |||
Linear Mode
