Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Can I assign a range to a formula when setting a conditional format?
'compare values in column B to adjacent values in column C '(lr = last row) xlapp.Workbooks(strXlsFile).Worksheets(sn(i)).Rang e _ ("B2:B" & lr).FormatConditions.Add _ Type:=xlCellValue, Operator:=xlGreater, Formula1:="C2:C" & lr 'apply formatting xlapp.Workbooks(strXlsFile).Worksheets(sn(i)).Rang e _ ("B2:B" & lr).FormatConditions(1).Font.ColorIndex = 11 This code results in: Error Number 5: Invalid procedure call or argument The problem, I think, is with: Formula1:="C2:C" & lr How do I assign conditional formatting to each cell in column B? Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
New Conditional Format Overriding Previous Conditional Format | Excel Discussion (Misc queries) | |||
copy conditional format to regular format | Setting up and Configuration of Excel | |||
Multiple conditional on conditional format formula | Excel Programming | |||
Multiple conditional on conditional format formula | Excel Programming | |||
Keep format after paste from other worksheets - conditional format or EnableControl solution doesn't work | Excel Programming |