I have a spreadsheet which has a column of dates, I would like to compare the dates with todays date to change the background colour of a cell to be either green, yellow or red, so that I can quickly look down the column to identify rows that require action.. i.e.
If the date in the column is more than a week ahead no action is required and the cell would show green.
If the date in the column is between 1 and 7 days ahead action is required and the cell would be yellow.
If the date in the column has passed action is overdue and the cell would be red.
Thanks
Pete
Bookmarks