Conditional Highlight: color change cell only if multiple others filled in

Question

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.

Answer 1

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

Answer 2

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

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