Forum Discussion
Using Buttons in Excel
Hi peoples As i am sure this is the case for most people at work, you get half way through one task before another task presents itself and then we prioritize. I am trying to create a spreadsheet fo...
thombell100 I would skip the check boxes and just use "x". The attached example may shed a light on how you want to conditionally format this based on "x".
Riny_van_Eekelen Many thanks for your reply... I think i finally understand... you are a superstar!!! Although any alternative suggestions on achieving the same outcome are still welcomed...
thombell100 Not a superstar, just not fond of these fancy buttons and check boxes. They need Control and other settings like cell links to determine which check box is checked or not. An "x" or 1 or 0 is much easier to work with. Just a personal opinion though.
- Riny_van_Eekelen I think i had almost got it but yes the sample you sent over gave me the light-bulb moment... the fancy button (although i do like fancy buttons) doesn't seem to be able to format incrementally like normal cells...? someone must have a solution so i can use the fancy ones...? Thanks for your help Riny 🙂