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