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 ?