I have a column in excel of multiple dates and some blanks, I need to highlight the cells different colors based on their date range calculating from Today. Example, cells with no date a certain color, cells older than 1 day but less than 6 months a certain color, cells older than 6 months but less than 11 months a certain color, cells older than 11 months a certain color.
Select the cellls to colour e.g. A1
Conditional Formatting
New Rule
Use a formula to determine...
4 Formulas needed
=(A1 < > 0)
format as "no date certain colour"
=(AND(A1 > TODAY()+1,A1 < EDATE(TODAY(),6)))
format as "less than 6 mth certain colour"
=(AND(A1 > =EDATE(TODAY(),6),A1 < EDATE(TODAY(),11)))
format as "6-11 mth certain colour"
=(AND(A1 > =EDATE(TODAY(),11)))
format as "more than 11 mth certain colour"
Use Format painter (paintbrush icon) to copy to other cells
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks