Faster way to do conditional formatting based on text?

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?
 

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

Forum statistics

Threads
1,213,524
Messages
6,114,117
Members
448,549
Latest member
brianhfield

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top