Conditional Formating

[Albert Mulder]

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.

 

[Mike H]

Hi,

select A3 then
format|Conditions format|Formula is
paste in this formula
=COUNTIF(B1:B10,1)>0
Select a colour
OK

Mike