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...
You make it look simple. But that example prompts a couple clarification questions:
- is it that light yellow if ANY ONE is checked, or only if first one?
- is it that orangey color if ANY TWO are checked, or only if first two are checked?
- and so forth, except for the foursome
That said, conditional formatting can easily be applied to an entire row, or selection of cells in the row. I'm surprised that you've not seen any examples of that. Just change the "Applies to" section to reference the entire row. Conditional Formatting (in my experience) often takes some trial and error to get it to do what you want; be patient.
- 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?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.
- I've never used checkboxes. If you find you need to use a helper column, my suggestion would be to just do away with the checkboxes and have a Y/N option (using data validation) for the entries. It amounts to the same thing, and is more straightforward.
