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 ?**

Parm- Dec 24, 2012 01:01PMKabir- Dec 26, 2012 01:27PMImmi- Dec 27, 2012 08:40AMBarrett Key- Jan 16, 2013 02:40PMNKL- Jan 25, 2013 02:30PM