Microsoft Office Tutorials and References
In Depth Information
Color Coding Cells in the Data
Figure 2.25. Highlight cells that contain a certain value.
Highlight cells that contain a certain value.
If you apply any of the formatting commands in the Quick Analysis and
don ’ t like the result, open the Quick Analysis again and choose Clear
The Text Contains icon only appears if you have text in multiple columns.
If your data has text in column A and the rest of the columns are numeric,
the Text Contains icon changes to Top 10%. Excel calculates the difference
between the Max and Min. Anything above 90% of that range is highlighted (see