undoing conditional formatting
 

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

undoing conditional formatting
 

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


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=484010

undoing conditional formatting
 

Oh it worked perfectly. Thank you so much. :) :) Great board here.


--
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

undoing conditional formatting
 

You're very welcome. Glad to help a neighbour.


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=484010