Font color change if cell if null

  • Thread starter Thread starter asljwgirl
  • Start date Start date
A

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
 
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
 
Thank you this worked perfectly

Eduardo said:
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
Click to expand...
 
Back
Top