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

Hi and welcome to the board

Supposing your date is in A1 enter the following conditions for

RED : =A1<DATE(YEAR(TODAY())-4,MONTH(TODAY()),DAY(TODAY()))
GREEN =A1<>""

Cell will stay default color if empty

Sorry but could you tell me exactly where do I put that conditions?

Thx

Use the Home ribbon - conditional formatting - New rule - use the " formula is" option

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post