Powered by Max Banner Ads
© 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.