Microsoft Office Tutorials and References
In Depth Information
by cell color, font color, or icon
You can use conditional formatting to set criteria and
then format your data based on that criteria. For
example, you can have the highest ten values in a
list appear in a particular color or font or with an
icon. You can have values that meet other criteria
appear in another color or font or with another icon.
See Task #33 to learn how to conditionally format
your data. You can then sort your data based on the
cell color, font, or icon you assign.
You can also manually assign cells a font or cell color.
Then you can sort cells by these colors. Select a
single column and then click a sort button on the
Ribbon to sort your data. You can nest your sorts.
In the Sort dialog box, you can select the color you
want to sort by and then tell Excel whether you want
to send items of that type to the top or the bottom
of the list.
Format your data with a color,
font, or icon.
Select the data you want to sort.
Note: If you have formatted your
data as a list, click in any cell in
Click the Data tab.
l The Sort dialog box appears.
Click here and select the column
by which you want to sort.
Click here and select whether
you want to sort by a value, cell
color, font color, or icon.