Scenario: I have a task recorded in an XL which is due on say 28th Feb. I want to use conditional formatting to highlight the row item in red, amber or green depending on when its due and the date today.
if today is 25th Feb or before, task is due on 28th, row should be green
if today is 26th or 27th Feb, task is due on 28th, row should be amber
if today is 28th Feb or any date in March and task was due on Feb 28th, row should be red
Can someone help with how to set this rule?