cell color fill depending on condition of 2 other cells

**lilozzy** · 06-23-2009, 03:51 PM

Afternoon everyone i am having abit of trouble working on an excel 2007 spreadsheet. i am pretty excel savy or atlast i think i am but i was hoping someone can help me out ill explain my spreadsheet below.

In cell I1 i have a tab called Color. i want the cells below I1 to be filled with one of 3 colors green, yellow, or red depending on whats in cell F "Status" (closed or open - in progress) and cell G ECD for estimated completion date.

Green - i need it to fill green if status is closed
Yellow - need it to fill yellow if ECD is any date greater than today and if status is open

Red - need it to fill red if ECD is todays date or older and status is open.

can anyone please help?

**shg** · 06-23-2009, 03:52 PM

Welcome to the forum, lilozzy.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.

**lilozzy** · 06-24-2009, 10:25 AM

Stormseed,
thanks it worked like a dream i have used conditional formatting before but i must have spaced it when using a formula in it like that thanks a bunch that will make my life alot easier.

**lilozzy** · 06-30-2009, 11:14 AM

ok i now have ben told that they want this to be viewed differently

now instead i need it to go red if the ECD(G column) is beyond 31 Jan 2010. and i need it to go yellow if the ECD is before 31 jan 2010. the below formulas were given to me from stormseed that worked but now need to change.

yellow: =AND($G2>TODAY(),$F2="open - in progress")
red: =AND($G2<=TODAY(),$F2="open - in progress")

can anyone help?