highlight consecutive duplicate rows (re-sending)

  • Thread starter Thread starter Phil Hellmuth
  • Start date Start date
P

Phil Hellmuth

My apologies if anyone responded to this when I originally posted. I
didn't download enough headers and I can't recapture the original....

I want to highlight any row that has the same data as the previous row.
For example, if A:3=A:2 and B:3=B:2 and C:3=C:2, I want to highlight
Row 3. I also want to repeat this logic throughout the spreadsheet.
Can I do with this with Conditional Formatting? Or, would I need to use
VBA...in which case, how would I code this?

Thanks in advance.
 
Back
Top