Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Robert
 
Posts: n/a
Default 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
  #2   Report Post  
Biff
 
Posts: n/a
Default

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



Reply
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
Condional formatting maccaz Excel Worksheet Functions 4 May 25th 05 03:25 PM
difficulty with conditional formatting Deb Excel Discussion (Misc queries) 0 March 23rd 05 06:13 PM
conditional formatting question Deb Excel Discussion (Misc queries) 0 March 23rd 05 02:07 AM
Formatting dates in the future Compass Rose Excel Worksheet Functions 3 January 17th 05 10:39 PM
Copy conditional formatting across multiple rows? Gil Excel Discussion (Misc queries) 1 January 11th 05 11:27 AM


All times are GMT +1. The time now is 06:54 AM.

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

About Us

"It's about Microsoft Excel"