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 ?
Configuration: Windows XP Firefox 3.0.4
The "secret" is to make the formula with "relative referencing", hence, if your formula looks like this:
|
Condition formatting more than 3 conditions formula Conditional formatting 2 cells the same highlight Conditional formatting excel 2007 less greater Conditional formatting for one cell in excel 2007 Conditional formatting last filled cell in row Conditional formatting no data in cell Conditional formatting, compare two dates Copying one function into more than one data cell Excel cell appears "more than once" Excel conditional formatting blank cells Excel conditional formatting percentages Excel if cell value more than 3 change color Excel retrieve conditional formatting vba Format cells excel bahasa indonesia Format that changes the appearance of a cell range How do you change the format of an apple ipod Vba code for conditional formatting What's a format card for cell phones