Microsoft Office Tutorials and References
In Depth Information
Color Coding Cells in the Data
Figure 2.24. Highlight numbers in the top 20% of values.
Highlight numbers in the top 20% of values.
I had never noticed this before, but Excel considers any text cell to be greater
than any number. Thus, all of the text cells get highlighted by this icon.
If you have a column of text beyond the first column, the Quick Analysis of-
fers a tool called Text Contains. It initially highlights the text value that
appears more often than any other text. Figure 2.25 shows the Communica-
tions sector highlighted. After you actually click Text Contains, you can
specify any particular text to highlight.