Hi,

I am facing a big challenge with my beginner vba programming skills.

I managed it to write a macro which creates a table, deletes columns and uses filters for two different columns.

Now my next step would be to color rows belonging to the same IP in one certain color, which changes to another color as soon as the IP changes.

I attached a sample file and my code I have so far. My problem with the code is that it needs a lot of storage capacity plus I do not know how to insert an IF function so that as soon as the IP changes the color will change as well (goal is to have only two colors in the end so that if you look on it you can easily see where the next IP starts)

I hope you can help me.
Marius

HighlightingMakro_MK07022015_v05.xlsm

Please Login or Register  to view this content.