Can someone help me add conditional formatting layers to this macro. My intent is to keep /maintain the same range, but add color to the pivot table to based on a different formula that would include over posted speed limit ranges. I just don't know where to begin the 'with' statements or if I have to add 'If' statement for each layer of conditional formatting.
0-9 MPH
=AND($H5>MIN(1,8),$H5<MAX(9))
10-14 MPH
=AND($H5>MIN(10),$H5<MAX(14))
15-19 MPH
=AND($H5>MIN(15),$H5<MAX(19))
20+ MPH
=AND($H5>MAX(20))
Please Login or Register to view this content.
Bookmarks