• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Date conditional formatting

Hi Friends,
COuld you please suggest a rules for conditional formatting cells with a date range- 05-May-2015
If given date is 14 days before today- highlight green
If given date is 5 days before today-highlight yellow
If given date is today or past today-highlight red
Example - Today is 06-May-2015
in cell A1 date given is 22-April-2015 , green
in cell A2 given date is 01-May-2015, yellow
in cell A3 given date is 06-May-2015, red
in cell A4 given date is 08-May-2015, red
thanks in advance
 
Back
Top