Advanced conditional formatting

[paulotuatail]

Hi I have a value in Cell E4 and a date in F4. I want to conditionaly format E4 if the date in F4 is less than NOW(); with any formating that is available IE Font colour or background colour.

TIA

Desmond

 

[Claus Busch]

Hi Desmond,

Am Thu, 13 Jun 2013 05:20:08 -0700 (PDT) schrieb (e-mail address removed):

Hi I have a value in Cell E4 and a date in F4. I want to conditionaly format E4 if the date in F4 is less than NOW(); with any formating that is available IE Font colour or background colour.

select E4 => Conditonal Formatting => new Rule => Use Formula .... =>
=F4<TODAY() => Format and choose your wished format


Regards
Claus Busch