Conditional formating in pivot tables

  • Thread starter Thread starter Neil
  • Start date Start date
N

Neil

Hi

Is it possible to have conditional formatting on a field in a pivot table.

I can apply conditional formatting to a range of cells, but if e.g. a wider
range of data is produced the formatting doesn't grow with it. I don't want
to have the 'Grand Total' columns have the same formatting as the rest of
the sheet, but depending on what data is brought back, they're not
necessarily in the same place.

Am I making sense?!

I'm using Excel 2002

Cheers

Neil
 
How many conditions will you have? If there's only one, you could check
for "Grand Total" in the heading, and apply one colour if the condition
is met. For other cells, apply a different colour if the condition is met.

Apply the conditional formatting to a range larger than the maximum size
of the pivot table.
 
How do i code something like:

If row 2 for this column = 'Grand Total'
then format = normal

???

Cheers

Neil
 
I've figured it out

If column has a grand total in it then format it...
=COUNTIF(A:A,"Grand Total")

If row has a grand total in it then format it...
=COUNTIF(1:1,"Grand Total")
 
Back
Top