Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying Rules in Excel
I have a rule in place that works (under Conditional Formatting). I just
don't know how to copy it down to other cells without creating the same rule over and over again for all subsequent cells. -- BB |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying Rules in Excel
Either use format painter, or Copy the cell and then select the other cells
and Edit/ Paste Special/ Format. Or you could have selected the whole range before you applied the CF. If you've got a formula in your CF conditions you may need to check whether you need relative or absolute addressing, and make sure you've got what you need. -- David Biddulph brewster56 wrote: I have a rule in place that works (under Conditional Formatting). I just don't know how to copy it down to other cells without creating the same rule over and over again for all subsequent cells. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying Rules in Excel
Thanks David, the Edit/ Paste Special/ Format does not work. If I try to
copy down a range in CF - whatever is true in the very first cell of the range - gets applied to all the other cells. It doesn't test beyond that first cell (I am using greater than or less than to evaluate). I am sure I am doing something wrong (with the exception of Edit/ Paste Special/ Format) -- BB "David Biddulph" wrote: Either use format painter, or Copy the cell and then select the other cells and Edit/ Paste Special/ Format. Or you could have selected the whole range before you applied the CF. If you've got a formula in your CF conditions you may need to check whether you need relative or absolute addressing, and make sure you've got what you need. -- David Biddulph brewster56 wrote: I have a rule in place that works (under Conditional Formatting). I just don't know how to copy it down to other cells without creating the same rule over and over again for all subsequent cells. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying Rules in Excel
Hi,
Show us the rule you are using. My guess is you overlooked David's point about absolute and relative cell references. For example, a rule like Formula is =A$1=MAX(A$1:A$10) will be useless if you copy it down, it would need to be =A1=MAX(A$1:A$10). Likewise =$A$1$B$1 would be useless for copying because you would need it to read A!B1 -- If this helps, please click the Yes button Cheers, Shane Devenshire "brewster56" wrote: Thanks David, the Edit/ Paste Special/ Format does not work. If I try to copy down a range in CF - whatever is true in the very first cell of the range - gets applied to all the other cells. It doesn't test beyond that first cell (I am using greater than or less than to evaluate). I am sure I am doing something wrong (with the exception of Edit/ Paste Special/ Format) -- BB "David Biddulph" wrote: Either use format painter, or Copy the cell and then select the other cells and Edit/ Paste Special/ Format. Or you could have selected the whole range before you applied the CF. If you've got a formula in your CF conditions you may need to check whether you need relative or absolute addressing, and make sure you've got what you need. -- David Biddulph brewster56 wrote: I have a rule in place that works (under Conditional Formatting). I just don't know how to copy it down to other cells without creating the same rule over and over again for all subsequent cells. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying Rules in Excel
I apologize for delay in responding. The holidays came in between and very
busy time of year at work. Here is my "logic" thus far ... A numeric value appears in G2 (in this case) as a result of a formula. The CF I have for G2 works based on the following: =$F$2$C$2 So if this evaluates to true - everything is fine. I just can't figure out how to copy it down to all the other cells. I have tried =F2:F11C2:C11, and I have tried =$F$2:$F$11$C$2:$C$11 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying Rules in Excel
CFFormula is: =$F2$C2 entered for G2
Use the Format Painter to copy down to G11 Or simply pre-select G2:G11 and enter the formula is: as above. Gord Dibben MS Excel MVP On Tue, 20 Jan 2009 08:09:01 -0800, brewster56 wrote: I apologize for delay in responding. The holidays came in between and very busy time of year at work. Here is my "logic" thus far ... A numeric value appears in G2 (in this case) as a result of a formula. The CF I have for G2 works based on the following: =$F$2$C$2 So if this evaluates to true - everything is fine. I just can't figure out how to copy it down to all the other cells. I have tried =F2:F11C2:C11, and I have tried =$F$2:$F$11$C$2:$C$11 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying Rules in Excel
Gord,
That worked perfectly thank you !! "Gord Dibben" wrote: CFFormula is: =$F2$C2 entered for G2 Use the Format Painter to copy down to G11 Or simply pre-select G2:G11 and enter the formula is: as above. Gord Dibben MS Excel MVP On Tue, 20 Jan 2009 08:09:01 -0800, brewster56 wrote: I apologize for delay in responding. The holidays came in between and very busy time of year at work. Here is my "logic" thus far ... A numeric value appears in G2 (in this case) as a result of a formula. The CF I have for G2 works based on the following: =$F$2$C$2 So if this evaluates to true - everything is fine. I just can't figure out how to copy it down to all the other cells. I have tried =F2:F11C2:C11, and I have tried =$F$2:$F$11$C$2:$C$11 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying Rules in Excel
Gord,
This worked perfectly - thank you !! "Gord Dibben" wrote: CFFormula is: =$F2$C2 entered for G2 Use the Format Painter to copy down to G11 Or simply pre-select G2:G11 and enter the formula is: as above. Gord Dibben MS Excel MVP On Tue, 20 Jan 2009 08:09:01 -0800, brewster56 wrote: I apologize for delay in responding. The holidays came in between and very busy time of year at work. Here is my "logic" thus far ... A numeric value appears in G2 (in this case) as a result of a formula. The CF I have for G2 works based on the following: =$F$2$C$2 So if this evaluates to true - everything is fine. I just can't figure out how to copy it down to all the other cells. I have tried =F2:F11C2:C11, and I have tried =$F$2:$F$11$C$2:$C$11 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying rules set on a range of cells | Excel Worksheet Functions | |||
Conditional Formatting - 3 Rules - Excel 2000 | Excel Worksheet Functions | |||
how do I set up a validation rules with two data rules | Excel Worksheet Functions | |||
Changing default or hidden rules within microsoft excel? | Excel Discussion (Misc queries) | |||
I need 5 conditional formatting rules-excel only allows 3 | Excel Discussion (Misc queries) |