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 for the formatting but I'm not finding anything that I really understand how to implement.
This is the sheet I'm working from, and I'm struggling with how to setup the conditional formatting.
the goal is to get excel to automate like this:
I'm sure the formula is simple but I can't find any examples that will highlight the whole row, the examples I find are only highlighting a single cell. Any guidance would be appreciated and helpful!
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.
