markstro
Board Regular
- Joined
- Sep 8, 2008
- Messages
- 106
I have a workbook saved as Excel 97/2003 workbook*.xls (compatibility mode) that uses the following VBA and conditional formatting to highlight the row/column the selected cell occupies.
VBA
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range) Application.ScreenUpdating = True
Conditional Formatting formula
=OR(AND(CELL("row")=ROW(),COLUMN()<=CELL("col")),AND(CELL("col")=COLUMN(),ROW()<=CELL("row")))
This combination works just fine in the 97/2003 workbook, but not another saved as *.xlsm format.
What changed between Excel 97-2003 and Excel 2007??
I run a compatibility check and get an overlapping conditional formatting problem, not sure how to fix it or if it is what is effecting my formatting to work.
I have used this formatting / code successfully on other workbooks saved as 97/2003 but have problems getting it to work in Excel 2007.
VBA
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range) Application.ScreenUpdating = True
Conditional Formatting formula
=OR(AND(CELL("row")=ROW(),COLUMN()<=CELL("col")),AND(CELL("col")=COLUMN(),ROW()<=CELL("row")))
This combination works just fine in the 97/2003 workbook, but not another saved as *.xlsm format.
What changed between Excel 97-2003 and Excel 2007??
I run a compatibility check and get an overlapping conditional formatting problem, not sure how to fix it or if it is what is effecting my formatting to work.
I have used this formatting / code successfully on other workbooks saved as 97/2003 but have problems getting it to work in Excel 2007.