Prev: How can I make this formula work?
Next: How to Reregister a given Excel version
From: delium on 19 Mar 2010 05:36
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
 | 
Pages: 1
Prev: How can I make this formula work?
Next: How to Reregister a given Excel version