Hello all,
I am planning to attempt something on a spreadsheet that I am building but thought I'd check if it is even possible before I dive headlong into trying it. Basically I have three assessment criteria that I would like to screen my data against and use conditional formatting to highlight any exceedences above the criteria. However, the three assessment criteria sets are not related to each other and so I was wondering if it was possible to set up checkboxes somewhere in the worksheet to toggle between criteria? I currently have three separate worksheets with one set of criteria and conditional formatting in each one but it would streamline my process if I could get them all on one sheet. Any help or suggestions would be appreciated.
Bookmarks