# Conditional formating - apply on more cells

Solved/Closed
Related:

- Apply conditional formatting to the selected cells
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- Conditional formatting if two cells match ✓ - Excel Forum
- Highlight cell if another cell contains specific text - Excel Forum
- Highlight cell if another cell contains any text ✓ - Excel Forum
- Conditional formatting if another cell contains - Excel Forum

## 3 responses

sheryljohnson
Posts
5
Registration date
Saturday November 1, 2008
Status
Member
Last seen
December 15, 2008
4

Updated on Nov 29, 2018 at 03:32 PM

Updated on Nov 29, 2018 at 03:32 PM

The "secret" is to make the formula with "relative referencing", hence, if your formula looks like this:

then remove the $ sign before the row number, so it will look like this:

With this, you actually don't need to copy the conditional formatting. You can select an entire range before applying it, and insert the formula as if you selected only the first cell at the top. Excel will know to apply the correct formulas to all the other cells in the range (assuming the range is a column).

Or you can apply this formula to the first row, and copy it with the format painter.

Good luck!

=$B$2>$A$2

then remove the $ sign before the row number, so it will look like this:

=$B2>$A2

With this, you actually don't need to copy the conditional formatting. You can select an entire range before applying it, and insert the formula as if you selected only the first cell at the top. Excel will know to apply the correct formulas to all the other cells in the range (assuming the range is a column).

Or you can apply this formula to the first row, and copy it with the format painter.

Good luck!

Jan 11, 2009 at 11:45 PM

Jan 16, 2009 at 06:55 PM