Toggle Formatting

Add a checkbox from the Forms toolbar and have the result in a cell which is used by the conditional formatting.


AND(------< CheckBoxResult)


Pasting data on top of cells that contain conditional formatting will delete the conditional formatting.
Conditional formatting is treated very much like a number format.
Copying a cell that contains conditional formatting will also copy the conditional formatting.



© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited TopPrevNext