MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Conditional Format

Posted by ren on November 16, 2001 11:56 AM

Excel 2000

I am trying to write a conditional statement for cell F32 that should give me the following results:

If H32=anything other than blank, then F32 remains black.

(I have a condition that chages F32 red if = today )

Posted by IML on November 16, 2001 12:27 PM

=NOT(ISBLANK(F32)) (nt)