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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting changing relative when copied to other cell
Robin
Two methods............ 1. Select all the cells to be formatted then enter the formula =B2<(E2+F2) Make sure Excel doesn't try to help by making the formula absolute......adding $ signs when you don't need them. 2. Select one cell and enter the formula then use the Format Painter to paint the other cells with that cormat. Gord Dibben MS Excel MVP On Wed, 5 Sep 2007 09:30:04 -0700, robbin wrote: 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? |
Reply |
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) |