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 |
All times are GMT +1. The time now is 01:10 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com