audiate
Board Regular
- Joined
- Jun 20, 2003
- Messages
- 79
Hello all
I use conditional formatting a lot, especially for text content. However, I find it frustrating that it takes so long to write the formatting rules. Suppose I have cells which can have any of these values:
Beginner
Intermediate
Intermediate II
Advanced
Expert
...in order for the different categories to show in different colours, I have to write five rules. What I really wish I could do is have another tab with just the five unique entries, format them as I'd like them, and then have a conditional formatting *look this up*.
I could have sworn I'd seen a demo once for something like this, but after fruitlessly searching the help menu, I figure I must have confused it with something else...
Is there any way to speed up writing conditional formatting rules?
I use conditional formatting a lot, especially for text content. However, I find it frustrating that it takes so long to write the formatting rules. Suppose I have cells which can have any of these values:
Beginner
Intermediate
Intermediate II
Advanced
Expert
...in order for the different categories to show in different colours, I have to write five rules. What I really wish I could do is have another tab with just the five unique entries, format them as I'd like them, and then have a conditional formatting *look this up*.
I could have sworn I'd seen a demo once for something like this, but after fruitlessly searching the help menu, I figure I must have confused it with something else...
Is there any way to speed up writing conditional formatting rules?