Conditional Formating
 

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.

Conditional Formating
 

Hi,

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

Mike

"Albert Mulder" wrote:

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.