I have a pivot table that can change in size by 100 or more rows each time I
refresh. I have set up conditional formatting in four different columns and
it works great. The problem is, if I set up the conditional formatting by
highlighting the cells in a current table, then when I refresh, if the table
grows larger, the formatting doesn't exist in the new rows of data. Can
conditional formatting be done to each field so that regardless of the number
of lines the conditional formatting will work? If so, please tell me how.

Thanks,
--
Julie