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!
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! Read More