Color (or shade) cells by customer nr

[Ronald]

Hi,

I was wondering if there is a (quite simple) solution for this:

I want to have cells with the same customer nr. the same background/cell colour.
Since it is for quite a big list and the customer nr's vary very much a conditional format on customer nr. doesn't help.

Another option could be that sub sequentially a group with the same cust.nr. has, let say, a gray background, the next group not, then grey again...

It's to clarify that those rows arw for the same customer.

Please see attached file, I've tried to clarify it with a simple example.

Best regards,

Ronald.

 

[NARAYANK991]

Hi ,

I do not know whether this solution is simple or not ; you can say.

Narayan

 

[Ronald]

Sorry for this late, late answer.

I've solve it as on the attached file.

 

[Dalia]

hi,

can you please make me understand the formula. i dint get it
Regards
Ambalika

 

[NARAYANK991]

hi,

can you please make me understand the formula. i dint get it
Regards
Ambalika

Hi ,

To whom is your question addressed ?

Narayan