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.