75 Essential Excel tips

Figure 5: Conditional formatting icon sets. When you apply conditional formatting such as a three-color gradient, you can identify relevant values within the data and get a better idea of where these values lie within the range of data in question. You can then reorganize this data with sorting options like Sort by Smallest to Largest or Cell ... ................
................