Sorry .... I need to expand on this thought. I figured out how to get a cell
to change for one variable with conditional formatting, however I have 5
possible variables of which I would like different colors for each. Can this
be done?

So for "V" I get a Dark blue fill, "H" I get another color and "A" I get
another color and so on.

--
Thanks
Dave


"Dave" wrote:

How do I get a cell to change the color fill automatically when specific data
is entered into a cell?

I am trying yo build a calender for the company emeployees to fill out their
vacation schedules. When they enter "V" into a cell, I would like that cell
to automatically change to a dark blue fill with white text.


--
Thanks
Dave