Hello,

I have a column with dates (day/month/year format)

For each date (row) I want that if that date is older than 4 years the cell goes red. Otherwise goes green.

So basically it is just comparing the date introduced with the current system date. If older than 4 years cell goes red, otherwise goes green.



Is that possible with Excel 2007?

Cheers