Not clear what you want done but Conditional Formatting can be used to color
cells based on value in those cells.

See help on conditional formatting.


Gord Dibben MS Excel MVP


On Sat, 25 Jul 2009 07:17:01 -0700, Skeetra27
wrote:

Can I make a certain cell color in colum B4:B61 = "REG SHIFT" in column I4:I61?
The I column currently has a drop down list of several choices, including
REG SHIFT - this I do not want to change. Please advise.

Christine