Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Color coding by items
I have a group of data that is in A1:K10,000. The data is sorted by
item numbers, which are in A. I would like to have the code go through and color code the changes. So if Item one is in A1:A14, I would like this to be one color. Then on A15:A18 which is a different item number, it woudl be a different color. I was thinking cycle through ColorIndex 36, 39, 37, 40, 38. Coloring each item from A:K. There is another thing that I am hoping can be answered as well. In Column C there is a sequence number. I would like to add a border around each sequence in each item. If in my example above Item one is in A1:A14, sequence one is in C1:C4, sequence two woudl be in C5:C8, sequence 3 would be in C9:C14. So it would put a border around each sequence whithin each item. So A1:K4 would have a border. Then A5:K8 would have a border. I know this is a lot, but is it possible. If you can give me some basic code to get going I am sure I can figure it out. I know how to do loops and for next but this seems a little more complicated then that. Thanks, Jay |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
color coding | Excel Discussion (Misc queries) | |||
Color coding cells | Excel Discussion (Misc queries) | |||
Color Coding Cells | Excel Worksheet Functions | |||
color coding | Excel Worksheet Functions | |||
Color coding | Excel Discussion (Misc queries) |