Conditional Formatting and pivot tables.

P

Phil Smith

I have a pivot table. My goal is to Color in Red the entire row, if a
particular field contains a negative number.

How would I go about this? Any Ideas?
 
P

Peo Sjoblom

Select the row by click in the row header, assume it was row number 4 and
the cell in question is C4

do format>conditional formatting, select formula is and

=$C$4<0

click the format button and select red pattern and then click OK twice
 

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

Similar Threads

Pivot table 7
Conditional Formatting 1
Conditional Format - Pivot Table 1
conditional formula 1
Question on the occupied field of the pivot table in excel spreadsheet 0
Surpressing rows and columns with zero values in a pivot table 1
Pivot Table - 3
Count funtion in Pivot Table 3

Top