I have certain cells that have data validation so that the user can only
input data that is listed on the same sheet on some other part of it.
the list contains 26 items not including the title, each one has it unique
cell formatting.
when the user tries to input data in the cells defined above, he gets to
choose one of the 26 items using a drop down arrow on the cells.
what I want now is:
when he selects one of the items the format of the cell should be changed so
that it would be exactly the same format saved on the items list.
it would be easy if I had more than just 3 conditional formatting, using
"Formula is" etc. too bad I only can do it using this method.

You can use worksheet-change event in combination with a select case
statement and list as many conditions as you want.

"Abdul" wrote:

I have certain cells that have data validation so that the user can only
input data that is listed on the same sheet on some other part of it.
the list contains 26 items not including the title, each one has it unique
cell formatting.
when the user tries to input data in the cells defined above, he gets to
choose one of the 26 items using a drop down arrow on the cells.
what I want now is:
when he selects one of the items the format of the cell should be changed so
that it would be exactly the same format saved on the items list.
it would be easy if I had more than just 3 conditional formatting, using
"Formula is" etc. too bad I only can do it using this method.

Excuse me, but what's a "worksheet-change event"?
where can I learn more about it?

I saw it under VB help, but the example shown in there doesn't include how to
change patterns or fill color.
more help is appreciated.