Macro code to delete conditional formatting

B

Bovine Jones

Hello again.

I've sure I'm missing something really obvious here, but is there an easy
way to select the whole of a spreadsheet and delete all of the conditional
formatting?

Thanks.

BJ
 
S

Stefi

It's really obvious:

Cells.FormatConditions.Delete

Regards,
Stefi

„Bovine Jones†ezt írta:
 
G

Gary''s Student

If you are comfortable with VBA:

Sub dumpum()
Cells.FormatConditions.Delete
End Sub
 
D

David Biddulph

The steps to go through are:
select the whole sheet, Format/ Conditional Formatting/ Delete/ select
conditions 1, 2, & 3/ OK/ OK.
 
B

Bovine Jones

Stefi/Gary - thanks... that's exactly what I was after.
David - thanks for your help... I'd got that bit covered but I wanted to
include it in a VBA macro.
 
S

Stefi

You are welcome! Thanks for the feedback!
Stefi

Bovine Jones said:
Stefi/Gary - thanks... that's exactly what I was after.
David - thanks for your help... I'd got that bit covered but I wanted to
include it in a VBA macro.
Click to expand...
 
Top