PDA

View Full Version : [SOLVED] Clearing Cond. Fmts from a Range



Cyberdude
05-26-2005, 11:54 AM
I frequently have to clear a range of both formulas and conditional formats. I know how to clear formulas, but is there a method for clearing conditional formats from a range? Something like "ClearContents".

Bob Phillips
05-26-2005, 01:12 PM
I frequently have to clear a range of both formulas and conditional formats. I know how to clear formulas, but is there a method for clearing conditional formats from a range? Something like "ClearContents".

Uh, ClearFormats?

Cyberdude
05-26-2005, 01:33 PM
Well, I guess that did seem like a stupid question, but I laboring under the delusion that ClearFormats cleared all formats except conditional formatting. I should have checked help before posting. Sorry.

Bob Phillips
05-26-2005, 02:06 PM
Well, I guess that did seem like a stupid question, but I laboring under the delusion that ClearFormats cleared all formats except conditional formatting. I should have checked help before posting. Sorry.

Wasn't that it was stupid, just funny, as the answer was in your words.:rotlaugh: