I tried this, and couldnt get it to work the way I would like.

However, I thought it might be a little bit better if, for ex,
C9 stays clear colored, and has a drop down with four choices. Each option
will give
D9 one of four diffferent colors. But also will allow you to enter the hours
from the drop down menu in D9 without losing color.

I messed around with a few different ways, but couldn't get it to work. Do
you think you could help me out on this?

Thanks for the assist before.

Avi

"daddylonglegs" wrote:


1. You say you are "colour-coding" do you mean using conditional
formatting? If you are and assuming "Vacation" etc. in D10 and hours in
E10...

select D10:E10
Format CF formula is
=$D10="vacation"
Select required formatting

Do this for all three options and D10 and e10 will both display the
same colour according to the category in D10

2. Do you mean you have multiple cells to sum? based on the above
something like

=SUMIF(D10:D20,"vacation",E10:E20)

this will sum hours in column E when the corresponding cell in column D
is "vacation"


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