N
NumLock
Another stupid inquiry from me, this time regarding conditional
formatting.
I have a cell that I would like to become shaded if any of four other
cells are not blank; however, I would like it to deshade if all four
cells are not blank. So I created conditional formatting with two
formulas:
#1: =OR(A1<>"",B1<>"",C1<>"",D1<>"") [SHADE CELL]
#2: =AND(A1<>"",B1<>"",C1<>"",D1<>"") [DESHADE CELL]
Clearly this isn't working, but I can't seem to figure out how to
write it so it works. It's shaded if there is any value in any cell,
and still shaded if all the cells have values. I'm sure the answer is
simple but it's just not coming to me. Thanks for the help!
formatting.
I have a cell that I would like to become shaded if any of four other
cells are not blank; however, I would like it to deshade if all four
cells are not blank. So I created conditional formatting with two
formulas:
#1: =OR(A1<>"",B1<>"",C1<>"",D1<>"") [SHADE CELL]
#2: =AND(A1<>"",B1<>"",C1<>"",D1<>"") [DESHADE CELL]
Clearly this isn't working, but I can't seem to figure out how to
write it so it works. It's shaded if there is any value in any cell,
and still shaded if all the cells have values. I'm sure the answer is
simple but it's just not coming to me. Thanks for the help!