Is there any way to make excel automatically change a cell's fill color if a
certain value is entered? I am making a schedule for employee shifts, and
would like to be able to have each person's name be associated with a color
without having to change the colors around each time I make a schedule.

Try "Conditional Format".
Limited amount of conditions through Excel 2003.
In Excel 2007/2010 "the sky is the limit".
Micky

--
והמשך/×™, ×*×�, לקרו×� ×�ת השורה הב×�×”:
***********
×�×� תגובתי עזרה לחץ/×™, ×*×�, על <כן בפס ×”×�ופקי התחתון!
***********
מיכ�ל �בידן
מ×*הל פורו×� "×�ופיס" ב"תפוז"
[Microsoft" Most Valuable Professional [MVP"


"joshuare" wrote:

Is there any way to make excel automatically change a cell's fill color if a
certain value is entered? I am making a schedule for employee shifts, and
would like to be able to have each person's name be associated with a color
without having to change the colors around each time I make a schedule.

Not really.......

In Excel 2007, conditional formatting can contain up to sixty-four
conditions, but in earlier versions of Excel, only three conditions are
supported.

In 2003 or ealier you would need VBA to get more than the three.


Gord Dibben MS Excel MVP

On Sat, 5 Dec 2009 13:22:01 -0800, ????? (????) ?????
<micky-a*at*tapuz.co.il wrote:

Try "Conditional Format".
Limited amount of conditions through Excel 2003.
In Excel 2007/2010 "the sky is the limit".
Micky