I use the same data list throughout a workbook. I would like to link an
element from the list to a specific cell background color. So everytime I
pick a data element it will change the cell to a color automatically without
having to manually do it. Any ideas?

W. Abkallah,

Check out Conditional Formatting (Format Conditional Formatting... (in XL
2002/2003...if 2007, sorry don't know))

If you need more help, please post more info.....like possible cell values,
what value do you want to be which color, etc...

HTH,

Conan




"W. Abdallah" wrote in message
...
I use the same data list throughout a workbook. I would like to link an
element from the list to a specific cell background color. So everytime I
pick a data element it will change the cell to a color automatically
without
having to manually do it. Any ideas?

Thanks. Works great!

"Conan Kelly" wrote:

W. Abkallah,

Check out Conditional Formatting (Format Conditional Formatting... (in XL
2002/2003...if 2007, sorry don't know))

If you need more help, please post more info.....like possible cell values,
what value do you want to be which color, etc...

HTH,

Conan




"W. Abdallah" wrote in message
...
I use the same data list throughout a workbook. I would like to link an
element from the list to a specific cell background color. So everytime I
pick a data element it will change the cell to a color automatically
without
having to manually do it. Any ideas?