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

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

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