Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using CF to change colour in cell based on date? | Excel Discussion (Misc queries) | |||
change cell colour according to date..... | Excel Worksheet Functions | |||
CHANGE COLOUR(CELL) FOR MANY DATES IF ARE SMALLER THAN ONE DATE | Excel Worksheet Functions | |||
past date cell colour change | Excel Worksheet Functions | |||
Change cell colour by date | New Users to Excel |