View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default 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