0

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/… – Cornelius Roemer Sep 25 '19 at 19:00
  • 1
    this ^ +1 : The values in the checkboxes (Menu > Insert > Checkboxes) are either true or false. – pjmg Sep 25 '19 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. – Cornelius Roemer Sep 25 '19 at 21:13
1

The formula you need for range A1:A is:

=and(A1<>"",counta(B1:J1)<>0)  

enter image description here

|improve this answer|||||

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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