Morning All,
I have a table:
Ref 1 2 3 4 5 6 Stage
11770 26-03-08 1246
12029 18-12-07 12345
12081 22-01-08 16
12177 04-12-07 126
12195 22-01-08 136
I want to colour in the relevant cells for each ref depending on the numbers in the stage column. So for the first line, the cells in columns 1,2,4&6 need to be shaded in. For the second line, the cells in columns 1,2,3,4,&5 need to be shaded in.
I already have a lot of conditional formatting set on the sheet so need to do this with a macro.
I have tried to write something but am having issues with it finding the 1 and shading in the correct column but then jumping out of the loop and on to the next cell.
Any help will be gratefully rec'd,
Thanks in advance.
Cheers,
MoonWeazel
Bookmarks