Greetings all
I have a macro that generates a weekly report that I am having a bit of difficulty with. There is a table detailing production as the main part of the report, I have it formatted with vba to alternate colors of rows and that all works fine I got this using the recorder:
The column I need to conditionally format is M and when I tried it it just cleared out all the alternating bands in that column where the conditions were met.Please Login or Register to view this content.
The problem I am having is highlighting lower than expected results and higher than expected results. I have a difficult time with conditional formatting without vba, but I am lost trying to get it coded using vba, but the report is rebuilt basically from the ground up every week so this needs to be part of the automated generation.
Any help would be greatly appreciated.
Bookmarks