A Abhijeet Active Member May 6, 2016 #1 Hi Please tell me i want from available dates 1st close date from today's date that should be highlight in Red Color 2nd close date from today's date higlight in Amber color & rest dates are highlight in Green color please tell me how to do this Attachments Book2.xlsx 9.2 KB · Views: 7
Hi Please tell me i want from available dates 1st close date from today's date that should be highlight in Red Color 2nd close date from today's date higlight in Amber color & rest dates are highlight in Green color please tell me how to do this
Chihiro Excel Ninja May 6, 2016 #2 Use CF. 1st Rule (RED): Set to Stop if True =$A2=SMALL(IF($A$2:$A$9>TODAY(),$A$2:$A$9),1) 2nd Rule (AMBER): Set to Stop if True =$A2=SMALL(IF($A$2:$A$9>TODAY(),$A$2:$A$9),2) 3rd Rule (GREEN): =$A2>TODAY() Any dates smaller than or equal to today will have no formatting. Attachments Book2.xlsx 10.4 KB · Views: 7
Use CF. 1st Rule (RED): Set to Stop if True =$A2=SMALL(IF($A$2:$A$9>TODAY(),$A$2:$A$9),1) 2nd Rule (AMBER): Set to Stop if True =$A2=SMALL(IF($A$2:$A$9>TODAY(),$A$2:$A$9),2) 3rd Rule (GREEN): =$A2>TODAY() Any dates smaller than or equal to today will have no formatting.
