Format Worksheet

Task: Format Worksheet		No	C1
No	Steps	Yes	No
C1.10 Conditional Formatting
01	Open spreadsheet package
02	Create or open exiting Workbook
03	*Type the data according to the sample datasheet provided (sample Document 01)
04	Select an area to format in the worksheet (G2:G16)
05	Homeà Conditional Formatting àmanage rule
06	New rule
07	Select format only cell that contain
08	Select condition (Greater then )
09	Type logic value (10000)
10	Click 'Format…' button
11	Select desired formatting options (Font, Color, etc.,)
12	Click 'OK' buttonà Click 'OK' button
13	Click 'new ruleà' button if you want to add another condition
14	Follow the steps 7 to 13 for other two conditions
15	Click 'OK' button
16	*Ask the instructor for the sample datasheet

To Apply Conditional Formatting:

1.       Select the cells you would like to format.

2.       Select the Home tab.

3.       Locate the Styles group.

4.       Click the Conditional Formatting command. A menu will appear with your formatting options.

5.       Select one of the options to apply it to the selected cells. A cascading menu will appear.

6.       An additional dialog box may appear, depending on the option you choose.

7.       If so, make the necessary choices, and click OK.

To Remove Conditional Formatting Rules:

1.       Click the Conditional Formatting command.

2.       Select Clear Rules. A cascading menu appears.

3.       Choose to clear rules from the entire worksheet or the selected cells.

To Manage Conditional Formatting Rules:

1.       Click the Conditional Formatting command.

2.       Select Manage Rules from the menu. The Conditional Formatting Rules Manager dialog box will appear.

3.       From here you can edit a rule, delete a rule, or change the order of rules.