Microsoft Excel 2013 announces the new feature that represents our data in different look that is conditional formatting. When we are working in long worksheets having a lot of rows and don’t understand which data is more important than other so for solving this issue we use Conditional Formatting feature. This feature applies colors, different rules, conditions and backgrounds to our worksheet cell’s content. With the help of this unique function we also highlight our cell’s name, date or show the difference between low, medium and high number values. Conditional formatting facilitate user for creating another method of data and make the worksheet easily understandable.
For creating our own conditional formatting we have to follow these directions.
Apply Conditional Formatting:
Select desired cells for applying conditional formatting rule.
 |
| Apply Conditional Formatting in Excel |
- Go to> Home button
- Click > Conditional Formatting Command, A drop down menu will appear.
- Take the mouse pointer to the desired conditional formatting type and select the rule which we want. For example we want to visualize the value greater than $4000.
 |
| Excel Conditional Formatting Command |
- Greater than dialog box will appear.
- Enter>desired values into the empty text box such as 4000
- Chose>Formatting style from the drop down menu from “With” edit box.
- We will select Green fill with Dark Green text for formatting.
- Then click> OK button.
 |
| Excel Greater than dialog |
- Conditional Formatting will be applied to selected cells.
Read More...
