| Home |
| Search |
| Today's Posts |
|
|
|
#1
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) | |||
Hybrid Mode
