Forum Discussion
How to highlight a row if different combinations of check boxes are true or false
Hi All, I'm working in an excel sheet and I'm looking to set it up so that it highlights a row in a table depending on which check boxes are true or false. I was thinking I could use a function f...
Hi Mathetes,
Thank you for the reply!
to clarify -
Yellow if only the first check box in E is checked
Orange if Checkboxes in E & F are checked
Green if Checkboxes in E, F & G are checked
Grey if checkboxes in E, F, G & H are all checked.
I think I'm having issues with the formula part, no matter the formula I use it doesn't yield any conditional formatting.
I'm also just learning that the checkboxes don't have a default true/false value so maybe I need to assign each checkbox a value in a hidden column?
Thank you for the reply!
to clarify -
Yellow if only the first check box in E is checked
Orange if Checkboxes in E & F are checked
Green if Checkboxes in E, F & G are checked
Grey if checkboxes in E, F, G & H are all checked.
I think I'm having issues with the formula part, no matter the formula I use it doesn't yield any conditional formatting.
I'm also just learning that the checkboxes don't have a default true/false value so maybe I need to assign each checkbox a value in a hidden column?
If you're using the newer check boxes the results are TRUE/FALSE. I've attached a sample workbook with the rules. The rules are written to not overlap.