| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro code to delete conditional formatting
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macro code to delete conditional formatting
It's really obvious:
Cells.FormatConditions.Delete Regards, Stefi €˛Bovine Jones€¯ ezt Ć*rta: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macro code to delete conditional formatting
If you are comfortable with VBA:
Sub dumpum() Cells.FormatConditions.Delete End Sub -- Gary's Student "Bovine Jones" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macro code to delete conditional formatting
The steps to go through a
select the whole sheet, Format/ Conditional Formatting/ Delete/ select conditions 1, 2, & 3/ OK/ OK. -- David Biddulph "Bovine Jones" wrote in message ... 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macro code to delete conditional formatting
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. "Bovine Jones" wrote: 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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macro code to delete conditional formatting
You are welcome! Thanks for the feedback!
Stefi "Bovine Jones" wrote: 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. "Bovine Jones" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting in a Macro | Excel Discussion (Misc queries) | |||
| Help With Macro Code?? | Excel Worksheet Functions | |||
| Adding a loop to conditional delete code | New Users to Excel | |||
| Conditional Formatting when inserting a row | Excel Worksheet Functions | |||
| cannot delete condional formatting | Excel Discussion (Misc queries) | |||
Linear Mode
