Class 12th Accountancy 2017 Set2 Delhi Board Paper Solution

Question 23

State the steps to change conditional formatting.

Answer

Following are the steps to change conditional formatting:

1. Make sure appropriate worksheet, table is selected in the show formatting rules for list box.

2. Optionally change the range of cells by clicking collapse dialog in the applies to box to temporarily hide and then select Expand dialog.

3. Select the rule, and then click Edit Rule. The Edit formatting rule dialog box is displayed.

4. Under select a rule type, click Format all cells based on their values

5. Under Edit the Rule Description in Format style list box, select 3-colour scale.

6. To select Minimum and Maximum type (any one of the following):

(i) Format highest and lowest value select lowest and highest value. In this case, we do not enter maximum or minimum value.

(ii) Format a number, date or time value select niumber and then enter minimum and maximum value.