Creating a Pick List in Excel 2003 with 5 Data Options and Corresponding Cell Fill Colors

Hello and sorry in advance that I am writing without Polish characters, I am in Singapore and the system does not allow me to use Polish characters :(

The problem I have with Excel is as follows:
I am trying to create a selection list so that after selecting the data, the cell in which the data is to be inserted should also change the color of the filling.
The pick-list consists of 5 data and 5 different fill colors to make the document more readable.
I tried to use the conditional formating option but this option only meets the conditions of 3 parameters :(

Can I do this using this function or is there any other solution? If so, please help.

Regards

Capital letters, commas (and more) are not "Polish characters" - get your post in order. [M]

Can you insert (attach) some simple example because I don't quite understand the problem (let's say I understand half of it)?

Do you definitely allow a solution with a macro?

ok i will try to insert jpg maybe then it will be easier to explain

https://obrazki.elektroda.pl/5089786700_1334362784.jpg

as you can see, I have defined colors for 5 parameters so that they are more visible in the sheet
the problem is that when adding new cells in the same column, using the selection list, the data from a to e were inserted, but together with the fill color
when it comes to macros I should be able to handle it with somebody's help
Best regards and thank you in advance for your help

As long as I have enough memory, it does not mislead me is called in Excel Conditional Formatting . Put in the same for all cells in the column and after the pain.

from what I know, conditional formatting in excel 2003 is only for 3 parameters a, b, c and in my case there are 5

So there is nothing left for you to do but write your conditional formatting support for certain sheet cells. Put it in the event Worksheet_SelectionChange

Can you tell me how to do it because it's probably beyond my strength !!!

Sorry to veto, I would suggest in the section Worksheet_Change



in Alt + F11 sheets
In the project with the name of your file, you click on the sheet you are interested in, e.g. Sheet1
and paste the above code there

And very beautiful. You can see that a professional wrote. You were faster.
I would suggest just for embellishments:

Works the same and looks better. And it has one more great advantage that I don't dare to mention.

I agree as much as possible :)

Alternatively, I would throw the line:
Case "": .ColorIndex = 0
because it actually meets Else (which I checked empirically )

but I support the amendment with both paws

You are great, thank you so much for your help !!!