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.

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