Conditional Formating

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Albert Mulder - 21 May 2008 19:03 GMT

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.

Reply to this Message

Mike H - 21 May 2008 19:16 GMT

Hi,

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

Mike

> 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.
[quoted text clipped - 4 lines]
>
> Else need to change it to another color.

Reply to this Message