How To Perform Conditional Format In MS Excel 2010
MS Excel offers a Conditional Formatting feature that allows user to format a range of values.
Simply choose Home Tab, followed by Style Group and select Conditional Formatting dropdown.
Different conditional formatting options
- Highlight cell rules – It helps to highlight the cells in the cell selection on basis of certain values, texts, dates or other parameters.
For instance, if you have to find cell with Amount 0 and Mark them as red, then choose Range of cell, followed by Home Tab, Conditional Formatting Dropdown, Highlight Cell Rules and finally Equal To.
Once you give a click on OK, all the cells with zero value will be marked as red.
- Top/Bottom Rules – This will help in highlighting the top and bottom cells based on values, percentages and other parameters. For instance, if you have to highlight top 10% rows, use the Top/Bottom rules.
- Data Bars – It brings up a palette with different colors data bars applied to the cell selection for indicating their values relative to each other.
This particular conditional formatting data Bars will appear in every cell.
- Color Scales – It brings a palette with different three or two colored scales which when applied to the cell selection indicate vales relative to each other.
- Icon Sets – It brings a palette that shows different set of icons and gets applied to each cell.
- New Rule – It brings the New Formatting Rule dialog box where users can define custom conditional formatting rules for all the cell selection.
- Clear Rules – It helps in removing the conditional formatting for the cell selection.
- Manage Rules – It opens up the Conditional Formatting Rules Manager for editing or deleting particular rules.