cannot delete contitional formatting

R

Robert

I have applied several conditional formats and had some conflicting results.
At this point, I would like to delete all conditional formatting and start
over. When I go to edit > go to > conditional formatting to highlight all or
same formatting, then go to format > conditional formatting, it is blank. It
does show my previous conditional formatting settings if I only select one
cell of the sheet that I know that it was applied to, so it is there. It is a
huge sheet, so I would like a way to identify and remove it all at once.
It almost seems that the "go to" method of highlighting is picking
additional cells that were not formatted.....
thanks in advance for any help,
Robert
 
B

Biff

Hi!
When I go to edit > go to > conditional formatting to highlight all or
same formatting, then go to format > conditional formatting, it is blank.
It
does show my previous conditional formatting settings if I only select one
cell of the sheet that I know that it was applied to, so it is there.
Click to expand...

The reason no settings show up when you select multilpe cells is because
there are probably different settings for some of the cells.

Edit>Go To (or F5 as a shortcut) does work.

I keep the Clear Formatting toolbar button on one of my toolbars to quicky
remove *ALL* formats. It removes all formats, not just conditional
formatting.

Biff
 
R

Robert

Biff, thanks for the response. Do you know if there any way or maybe a macro
that would go cell to cell and clear conditional only? It will create a lot
of work to clear all formatting.
thanks,
R.
 
B

Biff

Hi!

Just do as you tried initially:

Hit function key F5>Special>Conditional Formats>OK

With those cells selected goto Format>Conditional Formatting
Click the Delete button
Tick all the condition checkboxes
OK out

Even though no settings may appear this will still clear all the conditional
formatting of the selected cells.

Biff
 
G

Gord Dibben

Robert

This works for me.

CTRL + a to select all cells.

Format>CF>Delete>Condition1 and 2 and 3 if needed.

Will clear CF only, not other formatting.


Gord Dibben Excel MVP
 
R

Robert

This appears to have worked, thank you!. I was misled because I didn't see
the formatting and therefore thought I couldn't delete it as you said. I
thought about trying this earlier but thought......nah.....couldn't be.....:)
so I guess this qualifies as an "Excel secret"!
thanks again,
Robert
 
Top