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.
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.
