|Are you saying that the cell that denotes the "colors available" looks something like this?|
Red, Blue, Green
If so, tell us exactly what it looks like and what column it is in.
You said: "I need to insert a row below each style number for each color."
That means that for a style number with 3 colors you would now have 4 rows - the original and 3 new rows below the original one. Is that really what you want or do you just want a single row for each color with the original becoming the row for the first color in the list?
Posting Tip: Before posting Data or VBA Code, read this How-To.