If you want to highlight all the values greater than 140, click on the Greater option you will see below the window. Similarly, we can make use of “Color Set, Icon Set, Greater Than, Top Value and more importantly, we can clear the formatting with the “Clear” option.Ĭlick on the Color set to insert different colors.Ĭlick on Icon Set to get icons for your numbers. I have placed a cursor on “Data Bars” it has inserted data bars according to the size of the numbers. Just place a cursor on the required formatting option we can see the immediate impact in our data. We have “Formatting, Charts, Totals, Tables, and Sparkline’s”. Click on this icon to explore all the possible options. Once you select the data, we can see the Quick Analysis tool icon at the bottom of the selection.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |