Hi,

Am Tue, 23 Dec 2014 16:17:24 +0000 schrieb Quilp:

I have this formula in a cell:

=IF(TODAY()C9,"DUE,0)

select the cell with the formula = Conditional Formatting = New Rule
= Formula to determine.... and use this formula:
=TODAY()C9
and choose your expected format


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional