Still doesn't work.

The correct box is finally coloring in. However,
Condition 1 turns condition 2's color;
Condition 2 & 3 turn condition 1's color.

And besides, once I go to the neighboring cell to choose a number of hours
from the dropdown menu, the colors in that cell disappear anyhow, and it's a
clear color with the numbers in it.

Any ideas?

"daddylonglegs" wrote:


Select D9 and apply conditional formatting as follows

condition 1
formula is
=C9="vacaton"
blue formatting

condition 2
formula is
=C9="sick"
green formatting

etc.


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=503745