Chapter 23. Conditional Formatting
How can I highlight monthly stock returns so that every good month is highlighted in one color and every bad month is highlighted in another?
Given quarterly corporate revenues, how can I highlight quarters in which revenues increased over the previous quarter in one color and quarters in which revenues decreased from the previous quarter in another?
Given a list of dates, how can I highlight the weekend dates in a specific color?
Our basketball coach has given each player a rating between 1 and 10 for her ability to play guard, forward, or center. Can I set up a spreadsheet that highlights the ability of each player to play the position to which she’s assigned?
Conditional formatting lets you specify formatting ...
Get Microsoft® Excel Data Analysis and Business Modeling now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.