Hello again excel forum. I need a macro that does the following:

Highlights any row that has mismatch entries between col D & AA (blanks are okay) -- loop should run until GRAND TOTAL in col A.

First row data begins in D5 and ends in AA5

i.e.

row 1 has OTHER in L5 and CNS in R5 = this row should be highlighted

row 2 has OTHER multiple times = this row should not be highlighted

Basically, I'm looking for an easy way to distinguish row data that has mismatched information.

Please let me know if you have any questions. The website isn't letting me upload an example file, so post an email if you can help and I will send it your way.

Thanks again!