Hi, I am trying to use conditional formatting to color/highlight a cell but
am stumped.

Cell G2 has a date: 18 Jun 08
I need the cell to be colored/highlighted when 1 year has passed. SO, when
the spreadsheet is opened today on 7 Aug 09, the conditional formatting sees
that more than 1 year has passed since the date in cell G2 so teh cell is
highlighted.

How can I do this?

Thanks