Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 3
Default How to change the cell Colour when a date has been surpassed?

HI,

I need some help with excel.

I currently have a spreadsheet (as attachment) that i use to track incoming orders to our company, what i want is for the cell to change orange when the date (row F) is met i.e if it was due in on the 25/2/2011 and the date was 25/2/11 and then for the cell to change red if the date has been surpassed i.e it was the 26/2/2011.

Any ideas on how i can do this?

Thanks for your time

Brad
Attached Images
 
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using CF to change colour in cell based on date? Steve[_26_] Excel Discussion (Misc queries) 4 March 21st 10 10:52 PM
change cell colour according to date..... RichLive Excel Worksheet Functions 2 June 12th 09 03:54 PM
CHANGE COLOUR(CELL) FOR MANY DATES IF ARE SMALLER THAN ONE DATE SACKYROF Excel Worksheet Functions 2 October 30th 08 01:56 PM
past date cell colour change flasherr Excel Worksheet Functions 2 July 17th 08 06:17 PM
Change cell colour by date Dri New Users to Excel 5 February 8th 06 10:29 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"