I'm trying to figure out the proper conditional formatting formula to hilight a cell based on the date in that cell (and/or an adjascent one) representing the most recent date in the column.

Given data like this:

1/1/2011    v1
2/2/2015    v2
4/1/2010    c2
2/2/2015    d5

it would hilight rows 2 and 4, and optionally both columns A and B.

So basically the idea is a conditional format if the date in column A= the latest date of the range A1:A4

I'd like to see a variation that will work on just a single column or multiple columns based on the date in one column.

I'm trying to figure out the proper conditional formatting formula to hilight a cell based on the date in that cell (and/or an adjascent one) representing the most recent date in the column.

Given data like this:

1/1/2011    v1
2/2/2015    v2
4/1/2010    c2
2/2/2015    d5

it would highlight rows 2 and 4, and optionally both columns A and B.

So basically the idea is a conditional format if the date in column A= the latest date of the range A1:A4

I'd like to see a variation that will work on just a single column or multiple columns based on the date in one column.