I have a shift sign-up sheet in which I would like the cells in column A to be highlighted only once there is a value (name) in the corresponding cells in columns B:D.

In this example, I would like cell A1 to be highlighted as all shifts are assigned, but cell A2 to not be highlighted as not all shifts are accounted for. I tried =countif(B6:D6, "<>"), but this highlighted column A even if only one cell was filled in.

enter image description here


custom formula: =NOT(COUNTBLANK(B2:D2))



The rule you need to apply to range A1:A is:

=AND(B1:B<>"", C1:C<>"", D1:D<>"")

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.