LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Biff
 
Posts: n/a
Default

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.


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

EditGo 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

"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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
cannot delete condional formatting Robert Excel Discussion (Misc queries) 1 September 28th 05 07:31 PM
Hiding a worksheet while formatting it Bill Youngman Excel Worksheet Functions 2 May 11th 05 01:38 PM
difficulty with conditional formatting Deb Excel Discussion (Misc queries) 0 March 23rd 05 06:13 PM
Formatting dates in the future Compass Rose Excel Worksheet Functions 3 January 17th 05 10:39 PM
Conditional formatting not available in Excel BAB Excel Discussion (Misc queries) 2 January 1st 05 03:33 PM


All times are GMT +1. The time now is 04:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"