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

Your current approach of formatting the entire column is the only approach
that is effective. You can not format individual fields...
--
HTH...

Jim Thomlinson


"Julie" wrote:

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

Bummer.....thanks for the response!
--
Julie


"Jim Thomlinson" wrote:

Your current approach of formatting the entire column is the only approach
that is effective. You can not format individual fields...
--
HTH...

Jim Thomlinson


"Julie" wrote:

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