Ronald
Member
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.
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.