If you are in Excel, you can now highlight a row, column or entire spreadsheet with really eye-opening effects.
In the image on the right we opened the spreadsheet developed with the Excel 2007 tutorial. We highlighted the December column and then clicked Conditional Formatting. The drop down menu you see on the right appeared. We then clicked Color Scales and, when the area to the right of Color Scales appeared, we moved our cursor over the selections. As with other 2007 applications, when you move your cursor over the choices you will get a temporary preview of how your selection will appear.
Notice, in Conditional Formatting, there are also Data Bars and Icon Sets selections. If you were to choose these you would see small bar charts or little flags, smiley faces, etc. appear in the area you highlighted. And the list goes on and on. Really awesome!
No comments:
Post a Comment