How do I change cell colour when I put say 1 in the cell? I'm making a chart where I have the months of the year along the top and various activities on the side. By typing in 1 in the appropriate cell I want that cell to turn a specified colour, say green. Can I do this with Excel 2007?
Bookmarks