Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
change cell colour according to date.....
Hello I would be very grateful if anyone could help pont me in the right
direction with a formula to do the following: I have a date in field D9 and I need field I9 fill colour to change to orange if todays date is greater than 20 days after the date in D9 and then turn red if todays date is greater than 28 days after the date in D9 I hope this makes sense, I am not to hot at excel at the moment but am trying to learn Many Thanks Rich |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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 | |||
How can i change cell colour depending on month of date in cell? | Excel Discussion (Misc queries) | |||
How to change cell colour, X no days from inserted date in Excel? | Excel Worksheet Functions |