Change Cell Background

Shapper

Guest

Posts: n/a

8th Dec 2010

Hello,

I have a cell with a date and I would like to change the background
color to:

1 - Orange when Todays date is one month from the Cells date. Example:
Cell Date = 20-12-2010
Today = 08-12-2010

So it should become orange as Today it is within one month from
the Cell Date.

2 - Red when Todays date passes the Cells date.

How can I do this?

Thank You,
Miguel

« Anyone speak Japanese excel? | Re: Change Cell Background »

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

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Change background color of cell based on vlookup in cell	Antney	Microsoft Excel Misc	1	19th Oct 2009 10:55 PM
Cell Background Color Change --> Change Event	mark	Microsoft Excel Programming	5	7th Jan 2009 04:41 PM
Change Cell Value Based on Another Cell Background Color	=?Utf-8?B?SkFE?=	Microsoft Excel Programming	1	18th May 2007 07:47 AM
change background row color with change of date in a cell	=?Utf-8?B?VXJzenVsYQ==?=	Microsoft Excel Misc	5	17th May 2006 07:56 AM
Cell compare and based on the value change the cell background color	pftiv	Microsoft Excel Worksheet Functions	2	15th Jan 2004 04:24 PM