Hi,

I'm not following, what is in the five cells? how does 1,2,3,4,5 relate to
the example you are showing us 1,2,3,4? Do you want to format all the cells
one color when the user pick the word Five or do you want to format the cell
containing the number 5 or the cell with the word Five? Do you want to apply
the same color or do you want a different color for each word you pick? What
are the other words on the list and how will they relate to the numbers
1,2,3,4?


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Srajes" wrote:

Hi, I want to automatically change the color of a range of cells when a user
select a specific word from a drop-down list in a cell in that range of cells.

For example: user selects 'FIVE' would change the color of the cells
1,2,3,4,5(FIVE).

1 2 3 4 FIVE


Appreicate any help to implement this.
Thanks