Conditional formatting

N/A

1. Conditional Formatting

2. Introduction Excel 2010's has introduced a lot of advanced features to assist the processes of organizing data. Conditional formatting is one of the

3. Learning Outcomes Understand the concept of conditional formatting. Identify the different rules of conditional formatting. Use and apply different types of rules with appropriate values. Differentiate between the functions of different rules Identify categories of conditional formatting presets. Use and apply conditional formatting presets. Remove conditional formatting rules. Manage and modify existing rules from sets of data.

4. What is Conditional Formatting? With Excel's conditional formatting options you can apply formatting to cells based on the value of it. You can highlight and visualize the data using formatting such as colors , icons , and data bars .

5. Create Conditional Formatting Rule

6. To create a conditional formatting rule: Select the desired cells to format. In the Home tab, click the Conditional Formatting command. A drop-down menu will appear. 1 2

7. To create a conditional formatting rule: (Cont.) Select Highlight Cells Rules Select the rule ( Greater Than ). 3 4

8. To create a conditional formatting rule: (Cont.) From the dialog box, enter a value in the space provided. Select the formatting style . 5 6 Note: You can enter a cell reference instead of a number.

9. To create a conditional formatting rule: (Cont.) You will see that the formatting style you have selected will be applied to the cells that has a value Greater than what you have entered. Before After

10. To create a conditional formatting rule: (Cont.) Other Highlight rules can also be applied with the same steps: Less than rule : highlights the cells that have value that is less than the selected value. Between rule : highlights the cells with value which occurs between the selected values as shown in figure(1). figure(1).

11. To create a conditional formatting rule: (Cont.) Equal to rule : highlights the cells with the exact value you have entered.

12. Conditional Formatting Presets

13. Conditional formatting presets : Presets allow you to apply formatting to the needed data quickly. 1.Data bars 2.Color scales 3.Icon sets 1 2 3

14. To apply a conditional formatting preset : Select the desired cells to format. In the Home tab, click the Conditional Formatting command. A drop-down menu will appear. 2 1

15. To apply a conditional formatting preset : Select Data bars , then select the desired preset. You will see how presets rule has been applied to your selected data. 3

16. Remove and Manage Rules

17. Removing and Managing rules: Excel allows you to remove and manage all rules that have been added to the selected set of data. To Remove rules: 1 . Select the cells that have conditional formatting. 2 . In the Home tab, click the Conditional Formatting command. 2 1

18. Removing and Managing rules: To Manage rules: 1 . Select the cells that have conditional formatting. 2 . In the Home tab, click the Conditional Formatting command. 3 . Select Manage Rules. 2 1 3

19. Removing and Managing rules: 4 . Manage and modify the rules that are already added to the cells or Add new rules. You may add new rules, Edit existing or Delete rules. 4

20. Removing and Managing rules: 4 . Manage and modify the rules that are already added to the cells or Add new rules. You may add new rules, Edit existing or Delete rules. 4

21. Summery In this lesson you have learned what is conditional formatting and how it helps organizing the data and visualizing them. You have learned to apply rules, modify them and remove them.