Conditional Formating

[Guest]

I have a sheet containing the following formulas:
=IF(I5<TODAY(),"Delete","In Progress")
This works fine, however when I attempt to apply some conditional formating
to this and ask to display the results of "Delete" in red it does not work.
Could anyone please provide some guidance, I have checked through the help
and previous posts but still can't make it work. Even when I input the
formula and select OK, the next time I hover over the cell the formula does
not display in the formula bar

Thanks

 

[EdMac]

Hi Zooming,

Select cell where 'Delete' is. Go to format, conditional format.

select 'Cell value is' 'Equal to', ="delete"

Select the format conditions e.g font color, patten Click OK

If it does not work go back in and check that excel has not added an
extra set of quotation marks - if it has, delete them and click OK.

HTH
Ed

 

[Guest]

Hi zooming,

How about in 'conditional formatting', 'condition1', 'formula is':
=I5="Delete"
'format', 'patterns', 'red'

HTH