| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Including a variable into formatconditions
I am trying to convert the cell reference in the formula1 from a specific
cell to a program selected cell; B391 to cells(rowindex,columnindex) (actual code) Range("B996:Y998").Select Selection.FormatConditions.Delete Selection.FormatConditions.Add Type:=xlExpression, Formula1:="=AND(B391=1)" everything I try turns into an error Selection.FormatConditions(1).Interior.Pattern = xlGrid |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Including a variable into formatconditions
Formula1:="=AND(" & Cells(rowindex,columnindex).Address(0,0) & "=1)"
-- Regards, Tom Ogilvy "Chris" wrote in message ... I am trying to convert the cell reference in the formula1 from a specific cell to a program selected cell; B391 to cells(rowindex,columnindex) (actual code) Range("B996:Y998").Select Selection.FormatConditions.Delete Selection.FormatConditions.Add Type:=xlExpression, Formula1:="=AND(B391=1)" everything I try turns into an error Selection.FormatConditions(1).Interior.Pattern = xlGrid |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Including a variable into formatconditions
Thanks. I'll try this Monday when I get back to work
"Tom Ogilvy" wrote: Formula1:="=AND(" & Cells(rowindex,columnindex).Address(0,0) & "=1)" -- Regards, Tom Ogilvy "Chris" wrote in message ... I am trying to convert the cell reference in the formula1 from a specific cell to a program selected cell; B391 to cells(rowindex,columnindex) (actual code) Range("B996:Y998").Select Selection.FormatConditions.Delete Selection.FormatConditions.Add Type:=xlExpression, Formula1:="=AND(B391=1)" everything I try turns into an error Selection.FormatConditions(1).Interior.Pattern = xlGrid |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Including a third variable in a point diagram by color-coding | Excel Discussion (Misc queries) | |||
| FormatConditions VBA Bug? | Excel Programming | |||
| FormatConditions(1).Formula1 | Excel Programming | |||
| Including a variable number of columns in Excel Sum formula | Excel Programming | |||
| FormatConditions (fails in different Languages) | Excel Programming | |||
Linear Mode
