Color field if date equals certain criteria

's Computer Specifications

I have a list of dates in column A.
I have todays date in cell C1.
I want the date fields in column A to turn amber when they are equal to or
less than 15 days from todays date, then red when they are overdue.
Whats the formula for this please.

's Computer Specifications

Hi,

Select your range then

Format|Conditional format
Select formula is and enter the formula
=AND(A1<=TODAY(),A1>TODAY()-15)
Pick amber
Click ADD
Select formula is and enter the formula
=A1<=TODAY()-15
Pick red

You don't need to use the date in C1

Mike

"RC" wrote:

> I have a list of dates in column A.
> I have todays date in cell C1.
> I want the date fields in column A to turn amber when they are equal to or
> less than 15 days from todays date, then red when they are overdue.
> Whats the formula for this please.

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Add values based on text color with the criteria of a date	Peter Gonzalez	Microsoft Excel Worksheet Functions	7	15th Apr 2010 08:16 PM
How to: date field minus minutes equals new date	dst	Microsoft Excel Worksheet Functions	2	25th Dec 2007 06:38 PM
====> Debug query criteria date field all dates or selected date..URGENT ..	JOJ via AccessMonster.com	Microsoft Access Queries	2	16th Oct 2005 05:15 PM
sum an excel field that equals a criteria	=?Utf-8?B?UGF1bEM=?=	Microsoft Excel Worksheet Functions	1	26th Oct 2004 08:37 PM
SUM of values within date range which equals another field	Jennifer_3124	Microsoft Excel Misc	1	13th May 2004 03:03 PM