I have a spreadsheet keeping track of the various documents that students of mine have been turning in. The first column contains names and each column after tracks a particular document.

Is there a way for a student's name to be highlighted if any one of the other columns has a checkmark? I, therefore, would like the first cell of a row highlighted if there is an "x" anywhere in the rest of the row.

I hope this makes sense.

  • Hi Gilmario, yes that's possible. Have a look at this question for example which answers a very similar problem. webapps.stackexchange.com/questions/134782/… Sep 25, 2019 at 19:00
  • 1
    this ^ +1 : The values in the checkboxes (Menu > Insert > Checkboxes) are either true or false.
    – pjmg
    Sep 25, 2019 at 19:26
  • @Gilamrio: It'd be great if you could try to apply the method I linked above and update your question with whatever you got to. If you manage to make it work, answer your own question so that it's on the record for others. Sep 25, 2019 at 21:13

1 Answer 1


The formula you need for range A1:A is:


enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.