I'm looking to write a code that will automatically fill a cell with a specific color code when an specific # is entered in the cell above it. For instance.
Cells H11:K11 you can enter #'s 1 through 168 and also the letter 'N'.
under each of these cells H12:K12 i would like a specific color code filled in depending on the # above it.
A basic example of the colors is: 1=black, 3=red, 5=blue, 7=black, 9=red, 11=blue, etc. (the same goes for 2=black, 4=red, 6=blue) see attached color code chart for clarity.
So if 1, 3, 5 and N is entered in cells H11:K:11 the colors in cell H12:K12 should be B (black),R (red), BL (blue), W (white).
Now the kicker is that in cell D13 there are 3 options that may change the colors. (1.LV 2.HV or 3.NA)
LV = black (B), red (R), blue (BL), white (W) HV=brown (BR), orange (O), yellow (Y), gray (G) NA = user can enter any color regardless of the color
So to go back to the example. If HV is selected then 1=(BR) brown, 3, (O) orange, 5= (Y)yellow, N= (G)gray. etc.
Attached is my sample excel sheet, i have only started to change this to row 18 (so everything below that is an old format) Hope this makes sense.
Bookmarks