Advanced conditional formatting


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

:)
 
Ad

Advertisements

C

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top