Conditional Formatting in a pivot table

J

Julie

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,
 
J

Jim Thomlinson

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

Julie

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


Jim Thomlinson said:
Your current approach of formatting the entire column is the only approach
that is effective. You can not format individual fields...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top