Forum Discussion

Madsen_ACI's avatar
Madsen_ACI
Copper Contributor
Nov 01, 2024

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!

 

 

 

 

  • mathetes's avatar
    mathetes
    Silver Contributor

    Madsen_ACI 

     

    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.

    • Madsen_ACI's avatar
      Madsen_ACI
      Copper Contributor
      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?

Resources