Cell colour change.

Spaceace

Guest

Posts: n/a

26th Jun 2008

Please help.
I have 3 cells next to each other on a spread sheet. First cell has an order
date the second cell has a delivery date. I want the third cell to display a
differant colour when the todays date gets within a set amount of days of the
delivery date. Like a status cell. E.g Goes green within a week of the
date/goes red within 2 days of the delivery date.
please please help me.....

« Sumproduct on multiple sheets...please help??? | delete blank rows with functions »

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 cell colour on formula result change, no conditional format	roster_jon	Microsoft Excel Programming	0	2nd Dec 2008 12:11 PM
if cell colour is then change cell colour in range	=?Utf-8?B?dGlnZXI=?=	Microsoft Excel Programming	2	30th May 2007 05:32 AM
change current cell colour based on the value of adjacent cell on other worksheet	Rits	Microsoft Excel Programming	2	23rd Nov 2006 11:57 AM
change a cell background colour to my own RGB colour requirements	=?Utf-8?B?U3RlcGhlbiBEb3VnaHR5?=	Microsoft Excel Misc	4	16th Jun 2006 01:08 PM
How can i change cell colour depending on month of date in cell?	andy75	Microsoft Excel Misc	2	6th Jan 2006 07:46 AM