Conditional formatting comparing one line to the one below

Morning excel geniuses (genii?),

I have a sheet where data is generated daily. The line of data ends with the date at Column AW. If an error occurs the line is generated again and the previous line must be checked by hand.

I'm therefore looking for a way to make a row highlighted if the date in column AW matches the date in the line below it.

There are 100s of lines to go back through (800+) and needs to update each day with a new line so I'm assuming I'll have to apply the formatting to the entire sheet.

hi

this formula in conditional formatting should highlight any cell in a row where the value in column AW of that row is the same as in the row below, and that row is not blank.

=AND($AW1<>"",$AW2=$AW1)

you could apply the formula to every used cell in the sheet, but I'd suggest applying it only to the cells in column AW if that's where you check for duplicates.