how can I have a cell change color if a cell within a group has the value of
"1" and then revert back it the value changes.

A3 (Cell to change color)

B1:E10 need to see if any cell returnes "1" if so need to change A3 to a color

Else need to change it to another color.