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
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.