Coloring condition macro

[mikesal57]

HI GUYs ..

Need a macro to do this.......
columns....ac.....ad.....ae.....af......bw.....bx.....by

line 4.........4........3.......2......1......6........2......1
line 5........1........4.......3......5......4........5.......1
line 6.........4........2.......1.......6.....1........2.......4

I have 2 groups (1) ac,ad,ae,af & (2) bw,bx,by

column bw is red color
column bx is green color
column by is blue color

Now if a number in group one matches a number in group 2
then I want the cell to change to that color in group 2 and keep the info inside the cell

examples:
line 4 (ae) will change to color green with the 2 in it
line 4 (af) will change to blue 1
line 5 (ad) will change to red cell with number 4 in it
line 5 (ac) will change to a blue cell with number 1 in it
line 6 (ac) will change to blue 4
line 6 (ad) will change to green 2
line 6 (ae) will change to red 1

if no matches..leave alone

I hope this is clear...and thxs

mike

 

[Marcelo Branco]

beat me to it..lol

thxs MB

All the best

M.