ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   cannot delete condional formatting (https://www.excelbanter.com/excel-discussion-misc-queries/47579-cannot-delete-condional-formatting.html)

Robert

cannot delete condional formatting
 
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

Biff

See reply in .Functions

Biff

"Robert" wrote in message
...
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





All times are GMT +1. The time now is 07:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com