I am using Excel version 2007
I am trying to use conditional formatting to highlight cells with dates with different colors as they go further in the past. The following is what I am trying to accomplish:
If the date in the cell is between NOW and 180 days old = Green
If the date in the...