I have a sheet with many different conditional formats in which took a painful amount of time to create. I now want to have a toggle whereby I can remove the conditional formatting and put it back in if required.
The removal of the conditional formatting isn't an issue as I believe that I can use .FormatConditions.Delete but obviously that does what it says on the can and loses all formats.
Is there a way to either record what is already in place or maybe supercede the conditional formatting after button press so that instead of removing the format it just changes the cell colours on over the top of it?
Thanks.
The removal of the conditional formatting isn't an issue as I believe that I can use .FormatConditions.Delete but obviously that does what it says on the can and loses all formats.
Is there a way to either record what is already in place or maybe supercede the conditional formatting after button press so that instead of removing the format it just changes the cell colours on over the top of it?
Thanks.