The default style of the icon sets in Excel will rank the data automatically. Thus, the icon sets will appear in the range that you have selected. Here we choose the directional style with three icons in the list. And then in the submenu, choose one style that you prefer.In the drop-down menu, move your cursor on the option “Icon Sets”.Next click the button “Conditional Formatting” in the toolbar.Here we select the column B as an example. Select the target range in the worksheet.Instead of ranking cells, now you can also use the different icons to mark different values in the cells, with icon sets, so to make these values more intuitive, as below:Īnd now follow the steps below to see how it works. Suppose now you need to mark cells for the sales volume in the worksheet. It is also a small feature of the conditional formatting. ![]() Icon sets is a very useful feature in Excel. ![]() And in this article, we will talk about how to use this feature in Excel. In Excel, you can use the icon sets to mark cells with different values.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |