Skip to main content

Posts

Showing posts with the label icon
Icons in Excel Cells  - You can format your cells so that they have icons in them. The icons are used to illustrate the values. For example, here's a task list in Excel without icons. The 1 indicates that a task was complete, while the 0 indicates it is not complete: Now here's the same task list with icons: The second task list is far more useful! Let's see how it's done. Create the same simple spreadsheet as the one above. Now highlight the numbers from cell B2 to C5. With the cells highlighted, locate   Conditional Formatting   on the   Home   ribbon at the top of Excel. From the Conditional Formatting menu, select   Icons Sets : The Icons Sets are grouped into four categories: Directional, Shapes, Indicators, and Ratings. Click on the circles under Indicators. Your B column will then look like ours from the image at the top of the page. If you hold your mouse over each icon set, you'll see that it says something like "3 indicators",...