Data List

[W. Abdallah]

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?

 

[Conan Kelly]

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]

Thanks. Works great!

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