Change back color of cell

[zplugger]

Is it possible to change back color of A1 if A2orA3orA4 is selected? Then if another row is selected Cell A1 returns to normal.


z

[perimidt]

Hi

You would have to use a macro, like this one:

Please Login or Register  to view this content.

Right Click your sheet and select "View Code". Then choose "Worksheet" in the first drop-down and paste the code.

[daffodil11]

Hardly the prettiest way, but I went with

Please Login or Register  to view this content.

[zplugger]

Thanks guys, boy did I mess up but can use for furture. What I should of asked was
change the backcolor of A1 if B1,C1,D1 is selected Sorry

[zplugger]

Got Thanks guys, Just what I needed

Z