If/then excel formula

Copper Contributor

If cells b2:b16 are true (green) then b17 should turn green.  if any one of b2-b16 is not true (red), then b-17 is red.  What is that formula?

0 Replies