Conditional formating - apply on more cells
Solved/Closed
Hello,
i'm not so familiar with conditional formatting, so I would like to ask something:
I'm making a doc where Column A has number values, column B also numbers, of rank positions. Conditional formating of cell in column B would be: if number is greater than number in cell A, colour it Red, and if it is less than number in cell A, colour it green (rank position dropped down). Now, I managed that, but since the document has lots of rows, how do I apply the formating on the other cells in the column? If I make copy/paste to them, formatting doesn't apply on the whole column since it is not a function, but a cell format. And do I have to do the formating every day for every next column ?
i'm not so familiar with conditional formatting, so I would like to ask something:
I'm making a doc where Column A has number values, column B also numbers, of rank positions. Conditional formating of cell in column B would be: if number is greater than number in cell A, colour it Red, and if it is less than number in cell A, colour it green (rank position dropped down). Now, I managed that, but since the document has lots of rows, how do I apply the formating on the other cells in the column? If I make copy/paste to them, formatting doesn't apply on the whole column since it is not a function, but a cell format. And do I have to do the formating every day for every next column ?
Related:
- Apply the moderate effect smartart style
- How to apply SmartArt style in powerpoint - Guide
- Yamaha style player - Download - Musical production
- How to apply @ in laptop - Guide
- Ff name style - Download - Social media
- Apply watermark to all pages word - Guide
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
Jul 29, 2009 at 02:32 PM