View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
מיכאל (מיקי) אבידן מיכאל (מיקי) אבידן is offline
external usenet poster
 
Posts: 561
Default 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.