Hey Guys,
Here's the situation: I have a list of clients that have satisfaction scores that I want to attach conditional formatting to (specifically a Icon set of Green, Yellow, Red). Simple enough right? The problem is, depending on the client, there's 2 different scales of score (a 10 point scale and 7 point scale). So naturally I'll need to add 2 different conditional formats scales. In addition the order of the list of clients can change so I need a way for the conditional format to say if its client X to use this conditional format, if not, use the other conditional format.
I was thinking I create a name range list for this but I cant get it to work....Any help would be greatly appreciated.
Thanks,
Zeke
Here's the situation: I have a list of clients that have satisfaction scores that I want to attach conditional formatting to (specifically a Icon set of Green, Yellow, Red). Simple enough right? The problem is, depending on the client, there's 2 different scales of score (a 10 point scale and 7 point scale). So naturally I'll need to add 2 different conditional formats scales. In addition the order of the list of clients can change so I need a way for the conditional format to say if its client X to use this conditional format, if not, use the other conditional format.
I was thinking I create a name range list for this but I cant get it to work....Any help would be greatly appreciated.
Thanks,
Zeke