hi all,
i am trying to add a Conditional Formatting to a serie of cells -
D3: =B3<""
D4: =B4<""
D5: =B5<""
etc
the routine i have is this:
Workbooks(sTestcase). _
Sheets("TestScripts"). _
Range("A1"). _
Offset(iRowL + 1, 3).FormatConditions.Delete
sFormat = "=" & "B" & iRowL + 1 & "<"""""
Workbooks(sTestcase). _
Sheets("TestScripts"). _
Range("A1"). _
Offset(iRowL + 1, 3). _
FormatConditions. _
Add Type:=xlExpression, Formula1:=sFormat
the issue is, if i check on the Conditional Formating on the worksheet,
the formula is as follow:
D3: =E3<""
D4: =E4<""
D5: =E5<""
etc.
as you might expect this is not the desired result - if anybody could
clarify what i am missing or where i am going wrong, this would be
mostly appreciated.
cheers...
...jurgenC!
*** Sent via Developersdex
http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!