Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting changing relative when copied to other cell
How can I change the comparison formula for each cell the condition is
applied to. Example: B2<(E2)+(F2), I need to copy the condition to other cells but to change relative to the cell location, B3<(E3)+(F3) and so on down the column? I have tried this with and without the $ anchor, as well as with and without the cell reference in the formula (B2 or B3 as used here) but it does not seem to work. At one point the formula would change when copied to other cells, but it was comparing the previous row's cells [B4<(E3)+(F3)] and I don't know why or how this happened. Ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to copy an array without changing relative cell refferences? | Excel Worksheet Functions | |||
How to copy an array without changing relative cell references? | Excel Worksheet Functions | |||
How to copy an array without changing relative cell references? | Excel Worksheet Functions | |||
changing from relative to absolute cell reference in multiple form | Excel Worksheet Functions | |||
XL2K - Conditional Formatting relative to cell selection | Excel Discussion (Misc queries) |