Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
problem with conditional formatting and VBA (excel 2007)
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting in Excel 2007 | Excel Discussion (Misc queries) | |||
Conditional formatting Excel 2007 | Excel Worksheet Functions | |||
Excel 2007 - Conditional Formatting Problem with Percentages | Excel Worksheet Functions | |||
Using conditional formatting in Excel 2007 | New Users to Excel | |||
Conditional formatting problem in Excel 12 / 2007 | Excel Discussion (Misc queries) |