need macro for conditional formatting

geo741

New Member
Joined
Aug 18, 2011
Messages
3
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 !
 

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

seenfresh

Well-known Member
Joined
Jul 12, 2006
Messages
1,141
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

New Member
Joined
Aug 18, 2011
Messages
3
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 :)
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,099,113
Messages
5,466,755
Members
406,497
Latest member
Bryanlim

This Week's Hot Topics

Top