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.


--
lil'bit

married, muddled, and mistook
------------------------------------------------------------------------
lil'bit's Profile: http://www.excelforum.com/member.php...fo&userid=4306
View this thread: http://www.excelforum.com/showthread...hreadid=484010