Excel 2007 Refresh to odc MsAccess Connection losing conditional formatting - need VBA solution
Posted on 2010-11-07
I am having trouble after the data refreshes in 2007 with the conditional formatting. I have the developer "EnableFormatConditionsCalculations" set to True. I also have External Data Properties Data Formatting and Layout with the Preserve Column Cell Formatting checked. I've tried all of the "if the number of rows in the data range changes upon refresh" options.
I have 2 columns which are using the provided icon sets "3 arrows colored" and 1 column using the "3 traffic lights rimmed"
The worksheet columns are returning number data: ie 100 for green arrow, < 100 and > 0 for yellow arrow and <=0 for red arrow
Ive tried some of the other code I found in the solutions however I cannot seem to modify it to make my situation work. I placed a developer command button on my spreadsheet but I am lost getting Excel code to work.
Any help would be appreciated