View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Bill E Bill E is offline
external usenet poster
 
Posts: 8
Default View Conditional Formats on worksheet?

Bob, Bala and Jim, thanks for your direction! Apparently I had forgotten to
check "Notify me of replies" when I posted my question. I just found your
response a few minutes ago. -Bill

"Jim Thomlinson" wrote:

To degug CF's I find Goto | Special to be invaluable.

On a Sheet Hit F5 | Special
The dialog that comes up will allow you to select all CF's. Do that and then
you can add italicize of such to allow you to see which cells have CF's. You
can also specify which cells have the same CF as the cell youare on which
allows you to see what is using the current CF.

With a little practice you can debug your CF's pretty quick.
--
HTH...

Jim Thomlinson


"Bill E" wrote:

Is there an easy way to scroll over a worksheet to see what the Conditional
Formatting is for various cells? I know you can go through 'Format' -
'Conditional Formatting', but that can be very laborious. I'm reviewing a
fairly large worksheet where there are errors in the conditional formatting,
but most appear fine. I'd like to be able to scroll over cells and see what
the formatting is. Is this possible? Thanks! -Bill