Good day,

I am working with a range of dates where each row in columns (B:Y) contain various dates. I am attempting to highlight the adjacent cell of each row in column AA. Condition to be met: IF any one or more dates in a row are older than 1 year, AND the adjacent cell in AA is NOT blank, DO highlight the cell in AA. This would need to apply (per row) between 6 and 55.

I have attempted to use this formula: "=AND($B6:$Y6<=TODAY()-365,NOT(ISBLANK($AA6)))". With applies to: "$AA6". Expect that AA6 would be highlighted as per format selected. I then "pull down" to apply to the remainder of rows in the range.

But am getting incorrect and/or inconsistent results.

Hoping that I might have some guidance as to best option to achieve desired results.

Thanks in advance!

Peter H.
Virginia, USA