Today we talk on “Conditional Formatting”, which is very important facility of MS Excel. Conditional Formatting is an important command which allows you to apply different kind of formats on selected cell or range of cells as per requirement. In this post we discuss about how to apply formatting with the help of conditional formatting facility only Numeric Values in Excel entries on selected cell or range of cells in excel. It is a very useful technique used to highlight numbers from selected ranges of cells using conditional formatting facility in excel.
Meaning of Conditional Formatting:
Conditional Formatting feature in excel is used to allow or apply different kind of formatting on selected range of cells in active sheet like set background colors, borders, shading, apply styles on font that match certain given conditions.
For example, if you have a large database and you want to highlight or apply formatting only on numeric values on cell or range of cells in that case you must follow given steps to use conditional formatting facility in excel.
Note: You can also remove conditional formatting from entire sheet or selected range of cells by clicking on the Home >>> Click on the “Conditional Formatting” option in the “Styles” group >>> Click on the “Clear Rules” option > Select any required option either “Clear Rules from Selected Cells” or “Clear Rules from Entire Sheet”.
Create the following sheet in excel. (Before Conditional Formatting)
- Select the range of cell from A1:B10
- Click Home >>> Conditional Formatting >>> Then after click on New Rule >>> In New Formatting Rule box, Select Use a formula for decide which cells will format in select a Rule Type category.
- Now type following =ISNUMBER(A1) formula in Format values where this formula is true box.values
4. Click Format button -> Fill -> Select any color which you want to fill & set any type of border then click OK -> OK.
Excel Sheet (After Applying Conditional Formatting on Numeric Values only)
I hope you like this post. Give your important suggestion in the comment box and also share this article with your friends to show your knowledge in excel. Thanks.