Conditional Format Negative Numbers In Pivot Table

[walkerl8]

Hi All

Could anyone explain to me the best way in which to conditional format cells in a pivot table containing negative numbers.

For example, I want to have a red traffic light for if a values is equal to or greater than -1.0 (so -0.8;-0.6 etc) then an amber light for between -1.0 and -2.0 then a green for anything less than -2.0

Thanks for your time

 

[Scuderia]

Hi

-------------------------------------------------------------------------------------------------------

If you click on the pivot & then use the "select menu" within the "Options Menu"...
Choose..."entire pivot table"
now choose... "Select values" from the same menu option. The pivot now should only be highlighting the values.

Select...
Conditional Formatting
New Rule
Use a formula to determine which cells to format

Enter formula =IF(AND(G7<0,G7>-1),1,0) Format Red

(Substitute cell ref G7 with a value that is within your pivot)

--------------------------------------------------------------------------------------------------------

Do the above twice more however entering the following formulas instead

=IF(AND(G7<=-1,G7>=-2),1,0) Format Amber

=IF(G7<-2,1,0) Format Green


That should keep the formatting within the pivot table