I have conditional format rules set up using icon sets and it all work fine until I filter data. I have 2 filters, Driver and Date. If I filter by either one of these then the conditional formatting is maintained but if I apply the 2nd filter it isn't i.e filter by driver and then by date or filter by date and then by driver. Tried some VBA code I found but it doesn't work- Extend_Pivot_CF_To_Data_Area. Any help appreciated.