Chapter 5. Unleash Your Inner Spreadsheet
Being able to crunch numbers or build database tables is of little use if the data is difficult or impossible for others to comprehend.
Fortunately, you can mitigate this by using Excel's formatting tools. For example, you can apply themes to your workbooks to create a more polished and professional look, as well as add colors, patterns, and borders to cells to make them stand out. You can even use digital images as backgrounds in your worksheets.
To draw attention to cells that meet criteria you set, you can apply conditional formatting. For example, you might set a rule to highlight cells that contain values greater than, less than, equal to, or between a range of specified values. This enables you to ...
Get Office 2007: Top 100 Simplified® Tips & Tricks 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.
