problem with conditional formatting and VBA (excel 2007)

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top