Hello!,
I am working with 100 clients where 20 clients are premium. I have an excel log and when they request for a service I have listed them in my excel log. I know the list of my premium clients, but I do not know when they would make the request. My query is: when they will request and I would note down their name, then the cell will be filled by Red color. So that I could understand that this is my premium client.
I tried this with conditional formatting "Text that contain...." but this is not working here. Also, conditional formatting: "Duplicate values..." is not suitable as client may request more than once.
Please help.
Thank in Advance.
Roman
Bookmarks