Conditionally format dates in Column A
Posted on 2015-02-12
Column A of the current worksheets has entries with dates
I would like to apply conditional formatting to these dates with the following requirements:
If the date in Column A is within the next 10 days (from now) the date should get red shaded...
if the date in Column A is today the date should get yellow shaded ...
... and as soon as the date in Column A is in the past the Shading should change to green.
Help is much appreciated.
Thank you very much in advance