need macro for conditional formatting

[geo741]

Hi, i need to color the lines based on duplicates (in column B) for each date (column C). The duplicates or single data from a day must have an alternating color. Example atta

ched, thank you very much !

 

[seenfresh]

What is the purpose for color formatting the rows of data? Your objective is still a bit unclear....could you explain one as an example, for instance, why do you need Row#2 highlighted?

 

[geo741]

i consider column b a truck number (a delivery). where rows in column b are continuous duplicate, there is a single delivery with multiple goods, and i need that to delimitate the deliveries, to do more operations further. i hope you can understand

 

[geo741]

What is the purpose for color formatting the rows of data? Your objective is still a bit unclear....could you explain one as an example, for instance, why do you need Row#2 highlighted?

is ok?