Advanced conditional formatting

  • Thread starter Thread starter paulotuatail
  • Start date Start date
P

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

:)
 
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.
Click to expand...

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


Regards
Claus Busch
 
Back
Top