Re: Date Conditional Formatting

's Computer Specifications

Hi Jade,

Am Wed, 13 Jun 2012 15:11:39 +0000 schrieb Jade Summers:

> Green --> =$F166>TODAY()+181
> Red --> =$F166<TODAY()
> Yellow --> =TODAY()-$F166<180

for the red color use:
=AND(F166>0,F166<TODAY())

Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

's Computer Specifications

Hallo Jade,

Am Fri, 15 Jun 2012 12:12:46 +0000 schrieb Jade Summers:

> Thank you so much for your quick reply! Unfortunatly that isn't working
> for me. It's just turns all cells that were red (both dates and blank)
> no colour. However this does seem to fix the issue of putting
> 0/Jan/1900.

for me it works fine. Take a look at the range F166:F1100:
https://skydrive.live.com/#!/view.as...121822A3%21206

Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional Formatting - the date is between date A and date B	=?Utf-8?B?Tmlra2k=?=	Microsoft Excel Discussion	2	17th Sep 2007 02:22 AM
conditional formatting for date field - text or date	=?Utf-8?B?dHJldmk=?=	Microsoft Access Form Coding	2	26th Jan 2007 10:37 PM
conditional formatting for cell date to equal today's date	=?Utf-8?B?U2lzdGVyZWluc3RlaW4=?=	Microsoft Excel Worksheet Functions	1	14th Nov 2006 10:24 PM
i have two date fileds Opend date Due date, can i set default on due date so, its always = to open date on my data entry form1 Urgent	Mike Saifie	Microsoft Access Form Coding	1	9th Mar 2006 02:08 AM
Conditional Formatting - Can I select a select with Conditional Formatting?	Greegan	Microsoft Excel Worksheet Functions	5	31st Oct 2005 03:19 PM