Font color change if cell if null

[asljwgirl]

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

 

[Eduardo]

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]

Thank you this worked perfectly

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