Deleting conditional formatting

O

okiebound

I am unable to delete the conditional formatting on a
range of cells probably due to some cutting/pasteing.
The conditional format in greyed out in format menu. Any
help is greatly appreciated.
 
O

okiebound

Thanks for the reply. Sheet protection is off. As I use
Go To/Special/Condtional Formatting/All then the range is
highlighted with several exceptions in cells (obvously
those that were cut and paste) As it's highlighted I
cannot access Condtional formatting from the format menu
to delete conditional formatting. I hope I haven't
confused things. Thanks again
-----Original Message-----
You probably have sheet protection turned on.

http://www.mvps.org/dmcritchie/excel/grayedout.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

I am unable to delete the conditional formatting on a
range of cells probably due to some cutting/pasteing.
The conditional format in greyed out in format menu. Any
help is greatly appreciated.
Click to expand...


.
Click to expand...
 
Top