cells color

[malek]

helllo everyone,

In this file I want to alternate teh color of cells (white then blue...) and if the next cell has the same name as the one befor then I want them to have the same color. To make my self clear I put an exemple in the file (I did it manually), so now I want a VBA code to do that (I think it's more usefull when there is a larger amount of data).

Then for the same groupe of name I want to insert a ligne juste below.

I know I am demanding too much and it's maybe a little hard but I know also that there is masters of VBA in this Forum.

thank you !

 

[Marc L]

Then for the same groupe of name I want to insert a ligne juste below.

Salut, your attachment does not reflect that or … ?​

​

 

[malek]

Yes I didn't insert a line below each same groupe it's true but I want to add that if it's possible. I don't know if I answer your question.

 

[Marc L]

If a line is inserted between each group so the color is not necessary anymore …​

​

 

[malek]

Aah okay I see. It's not necessary finaly. Thank you

 

[Marc L]

But the question is why inserting a blank row - as Excel does not like non contiguous data - so what's for, what's next ?​

​