Associating a fill color with a cell value

[joshuare]

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"

 

[Gord Dibben]

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