Page 20 - Code & Click - 7

1
Removing Conditional Formatting
To remove conditional formatting:
1. Select the cells on which conditional formatting
is applied.
2. On the Home tab, click the Conditional
Formatting button in the Styles group.

A drop-down menu appears.

2

3. Point to the Clear Rules option and select the Clear
Rules from Selected Cells or Clear Rules from Entire
Sheet option.
Excel removes the conditional formatting as per the
selected option.

3

USING FORMAT PAINTER 2

The Format Painter in Excel allows you to copy all the
formatting applied to one cell to other cells, easily and
quickly.
To copy formatting using Format Painter:

1. Select the cell that contains the formatting you want
to copy.

2. On the Home tab, click the Format Painter button
in the Clipboard group. 1
The mouse pointer changes to a paint brush pointer.

3. Click and drag the paint brush pointer over the cells you want to format.

3

The cells are formatted the same way as the selected cell.

18