Hi,
I know how to highlight duplicate inv numbers however, most of my cell contents in column A are repeated inv numbers so its not very helpful. Is there a way that:
1. None duplicates/repeated remain unformatted
2. Repeating Inv numbers have there own colour relevant to that invoice number
3. Or at least repeating invoice number have alternating 2 colour so I know when the invoice number has changed.
Open to VBA solution if required.
Overall as long as theres a colour break/change of colour when repeating inv numbers in col A stop repeating. eg alternating colour change blue and yellow when repeating inv numbers change and no fill for none duplicates.
*so A20 inv no 22541 no conditional format as not a duplicated inv number. Overall report is an Inv item report.
Many Thanks
Gareth
I know how to highlight duplicate inv numbers however, most of my cell contents in column A are repeated inv numbers so its not very helpful. Is there a way that:
1. None duplicates/repeated remain unformatted
2. Repeating Inv numbers have there own colour relevant to that invoice number
3. Or at least repeating invoice number have alternating 2 colour so I know when the invoice number has changed.
Open to VBA solution if required.
Overall as long as theres a colour break/change of colour when repeating inv numbers in col A stop repeating. eg alternating colour change blue and yellow when repeating inv numbers change and no fill for none duplicates.
*so A20 inv no 22541 no conditional format as not a duplicated inv number. Overall report is an Inv item report.
Many Thanks
Gareth