undoing conditional formatting

  • Thread starter Thread starter lil'bit
  • Start date Start date
L

lil'bit

Hello and great day today. I use conditional formatting to find an
error(s) in many rows and columns when my grand totals aren't matching
both down and across. I might have 15 columns and 45 rows with data and
currency listed. I must make sure each row across matches to a grand
total and same down with the columns.

The conditional formatting is great for high-liting discrepancies But
it also highlites rows that are not really errors when put together
with another row. So I fix the row with an actual error but how do I
get rid of the highlite on the rows which are not really errors. I
can't use undo because then I'm back where I started. Thank you.
 
Try this:
Highlight the cells in the row where you want the CF removed
Select Format > Conditional Formatting
Click on Delete and put a check mark in the box indicating the CF you
want removed
Then hit OK and another OK
 
Back
Top