| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I reference cells in CF formula within loop
Rick,
Thank you, I think that is the new process I needed to learn. Assuming you want relative referencing, try it this way... For Each C In Range("A1:C3") C.FormatConditions.Delete C.Select C.FormatConditions.Add Type:=xlExpression, _ Formula1:="=" & C.Address(0, 0) & "<" & C.Offset(10).Address(0, 0) C.FormatConditions(1).Interior.ColorIndex = 36 Next John Keith |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to reference two cells to construct formula | Excel Programming | |||
| Loop for formula on one sheet with reference from another sheet | Excel Programming | |||
| Putting formula in cells from a loop | Excel Programming | |||
| For Each ... Next loop - need to reference the loop variable | Excel Programming | |||
| My formula screws up other reference cells... | Excel Discussion (Misc queries) | |||
Threaded Mode
