D
delium
Hello,
i have a problem with conditional formatting and VBA (excel 2007).
at first here is a screenshot of my conditional formula
http://img156.yfrog.com/i/bugjz.png/
as you can see, the formula depends on B1 but it is relative. so far so good.
but if i go through the cells with VBA the formula for all cells is the
same, (e.g. =B4="yellow")
if i do the same thing in excel 2003, vba shows the correct formulas:
=B4="yellow"
=C4="yellow"
=D4="yellow"
=E4="yellow"
=F4="yellow"
is this a known bug or do i something wrong?
this is my testcode:
Sub test()
Set myRange = ActiveSheet.Range("B3", "F3")
For Each myCell In myRange
For Each myCondition In myCell.FormatConditions
MsgBox myCondition.Formula1
Next
Next
End Sub
i have a problem with conditional formatting and VBA (excel 2007).
at first here is a screenshot of my conditional formula
http://img156.yfrog.com/i/bugjz.png/
as you can see, the formula depends on B1 but it is relative. so far so good.
but if i go through the cells with VBA the formula for all cells is the
same, (e.g. =B4="yellow")
if i do the same thing in excel 2003, vba shows the correct formulas:
=B4="yellow"
=C4="yellow"
=D4="yellow"
=E4="yellow"
=F4="yellow"
is this a known bug or do i something wrong?
this is my testcode:
Sub test()
Set myRange = ActiveSheet.Range("B3", "F3")
For Each myCell In myRange
For Each myCondition In myCell.FormatConditions
MsgBox myCondition.Formula1
Next
Next
End Sub