Latest posts by techwriter (see all)
- Hazards of Poorly Written Technical Documentation - December 26, 2016
- Get an ‘A’ on Your Next Research Paper With These 6 Simple Steps - November 28, 2016
- An Amazing and FREE Source of Magazines and Periodicals — ISSUU - November 25, 2016
© Ugur Akinci
MS Excel 2010 has a lot of ways to filter the cell data according to various CELL RULES and highlight the result for easy visual recognition.
Select Home tab and click Conditional Formatting button to display the options available:
(Click images to enlarge them)
Click Highlight Cell Rules to display the various rules available:
Let’s select all cells LARGER than a given value, like 200:
Click OK for the result:
Selecting all cells LESS THAN 400:
The same example with a DIFFERENT coloring rule selected from the drop-down menu:
NOTE: Be careful about applying one rule after the other since their cumulative effect may not be what you want. Always make sure you select the original unfiltered data table first.
Here is another example: SELECTING DUPLICATE VALUES.
By using the CELL RULES feature you call also accomplish selecting cells
between values A and B
have a specific value that equals to X
with text that contains a specific alphanumeric string
with a certain date occuring:
Play around with different cell rules to familiarize yourself with all the wonderful filtering option MS Excel 2010 provides.