Random Excel Tip of the Day
Ok, well we don’t really do a tip every day, but today we received an urgent call on the data red phone asking us about cell coloring. So here’s the answer — it’s an old favorite that falls in the seems-much-harder-than-it-is category:
Q: In Microsoft Excel, how do I set it to automatically have cells change color (like red and green) depending on the value in the cell?
A: Highlight the cells, then choose “Conditional Formatting”, in the “Format” menu. It’s great for those visual learners among us. Type it in to the Help system or Google for more details.
Easy, right?
Advertisement
