Conditional Formatting in a pivot table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
Your current approach of formatting the entire column is the only approach
that is effective. You can not format individual fields...
 
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...
 
Back
Top