PC Review


Reply
Thread Tools Rate Thread

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
 
Reply With Quote
 
 
 
Reply

Thread Tools
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


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:16 AM.