Hi,

I'm trying to make a conditional format when the result of a formula
results in a value being entered in a cell.

I'm using Excel Xp and my formula is as follows.

=IF(F160="Need Info",TODAY()-S160,"")

I've tried using formulas like >0, <>"", <>BLANK etc. but they all
seem to fail. All cells are formatted, even entirely blank cells, as
if the condition has been met.

BTW, is this formula better strategically than the above formula.

=IF(F160<>"Need Info","",TODAY()-S160)

Just curious.

TIA!!!

Norm