Conditional formatting - Look in range of dates - Highlight different cell if...

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

Thanks very much, the above recommendation works best for my current application. Though your below recommendation will come in very handy with future apps as well.

Thanks again!

Peter H.
Virginia, USA