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
|