Excel 2003 color drop down menu limit of 3?

[Closed]
Report
-
 Blocked Profile -
Hello,
I am working of Excel 2003. I already created a drop down menu which has 6 items in it. When I get to the part about "Conditional Formatting", I only get three options to color code the items in the list. I want to be able to color code all 6 items. I know it can be done, because I am working from a document that already has 4 items in the drop down list. But no one knows the password, as it was changed w/out permission. So, I am creating a new document with an updated list but with two additional items added in the drop down list. How do I get all 6 items to change color when either one of them is selected?

1 reply


Greetings,

Please, bare in mind that before any answer given on the forum, you should know that there are volunteers who give their time trying to solve user problems. They do have a life other than this forum including me.

Therefore, it is specifically requested from Kioskea forum users to show their respect. For this, the use of polite expressions is a minimum.
https://ccm.net/contents/948-terms-of-use-for-ccm-respect-for-others#politesse

To say please, thank you, appreciate, grateful, etc... is common courtesy when you want something, especially help!

You must copy, modify and repost your message respecting the politeness charter.

We trust that you understand.

Moderator