Copying Conditional Formatting

In Excel, conditional formatting is considered part of the regular formatting of a cell. If you want to copy conditional formatting from one cell to another, you can do so by simply copying the cell and pasting it (or its format) to another cell. If you want to copy a conditional format to a range of cells (and only the conditional format), the easiest way to do so is by following these general steps:

1. Select the range to which you want the conditional format copied. Make sure, however, that the cell whose conditional format you want copied is part of the range.
2. Choose Conditional Format from the Format menu. You will see the Conditional Format dialog box. The format should already be filled in.
3. Click your mouse on OK.

That's it. Excel does the rest and copies the conditional formatting, as you desired.