Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Advanced conditional formatting
13 views
Skip to first unread message
paulot...@aol.com
Jun 13, 2013, 8:20:08 AM6/13/13
to
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
:)
TIA
Desmond
:)
Claus Busch
Jun 13, 2013, 8:25:50 AM6/13/13
to
Hi Desmond,
Am Thu, 13 Jun 2013 05:20:08 -0700 (PDT) schrieb paulot...@aol.com:
> 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
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
Am Thu, 13 Jun 2013 05:20:08 -0700 (PDT) schrieb paulot...@aol.com:
> 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.
=F4<TODAY() => Format and choose your wished format
Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
0 new messages