Is it possible to format a row based on a text value compared from a cell in
that row to a cell in the row above it?

I review a report daily that is about 200 pages long, of which 80% of it is
duplicate information.