Changing the fill colour of 2 other cells based on another cell's outcome

I need to fill 2 other cells with varying colours dependant on what is chosen within another cell.

I have a drop-down list in cell A2 to select either ON SITE, ACTIVE or CANCEL.

What I need then basically is...
if A2 equals 'ON SITE' then fill other two cells (A3 and B1) GREEN
if A2 equals 'ACTIVE' then fill other two cells (A3 and B1) YELLOW
if A2 equals 'CANCEL' then fill other two cells (A3 and B1) RED


Any ideas how this can be done? [File attached]

Hi nathansav

Is there any way you could update the Excel file I attached to my original post to reflect your comments...I'm not too sure how to do this myself.

Would really appreciate it if you could.

Rgds
Danny1982

HI ,

Check this.

Punnam

Punnam

How can I then copy this conditional formatting easily for a series of cells? When I try and apply the conditional formatting to other cells, this wont work as the format is fixed on cell A2 changing. [file attached]

How can I get them working independantly of one another?

HI Danny,

You need to do some modification like as follows,
1) Remove all absolute reference .
Punnam

Hi Punnam

Is there any way you could update the Excel file I attached to my previous post to reflect your comments...I'm not too sure how to do this myself.

Would really appreciate it if you could.

Rgds
Danny1982