Associating a fill color with a cell value
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.
|