How can conditional formatting be changed ? Explain.

To change a conditional format following can be done: 1. Make sure that appropriate worksheet, table of Pivot table report is in theShow formatting rules for list box. 2. Optionally change the range of cells by clicking 'Collapse Dialog' in the Applies to box to temporarily hide the dialog box, by selecting the new range of cells on the worksheet and then by selecting '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 the format style. List box select $\displaystyle 3$ colour scale. 6. To select a 'Minimum' and 'Maximum Type' do one of the following. • Format lowest and highest values. Select Lowest Value and Highest Value. In this case we do not enter a Minimum and Maximum Value. • Format a number, date, or time Value. Select Number and then enter a Minimum and Maximum Value. • Format a percentage. Select it and enter Minimum and Maximum valid Values from $\displaystyle 1$ to 100. Do not enter percentage sign. • Format a percentile, Select percentile and enter valid values from $\displaystyle 1$ to $\displaystyle 100$ minimum and maximum Values. • Format a formula by selecting Minimum and maximum Values.