I am making a pivot chart. There is requirement that when ever we refresh
the data on the chart all the fields which score less than 95% sshould turn
red. Just to highlight that they have scored badly. I have old program
written on 97 by someone else and this thing is happening in that program.
However, I am not able to do that.

Attached is a part of the Pivot Chart in which the debris 93.4% is showing
up in red color automatically.

DEBRIS 93.4%
DELAMINATION 100.0%
DENTS AND LUMPS 91.8%
FLATNESS 100.0%
FORKLIFT DAMAGE 99.5%
LENGTH 97.0%
LINE DAMAGE 97.6%

Please let me know if you the answer to the query or if you need more
information.

Amol

(909) 997 7030

Hi Amol Joshi,

Run a little macro

Sub SetPivotCondFormat()
For Each pvt In ActiveSheet.PivotTables
With pvt.DataBodyRange
.FormatConditions.Delete
.FormatConditions.Add Type:=xlCellValue, Operator:=xlLess, _
Formula1:="0.95" ' change the value here to suit
.FormatConditions(1).Interior.ColorIndex = 3
End With
Next pvt
End Sub

Ed Ferrero
http://edferrero.m6.net


I am making a pivot chart. There is requirement that when ever we refresh
the data on the chart all the fields which score less than 95% sshould
turn
red. Just to highlight that they have scored badly. I have old program
written on 97 by someone else and this thing is happening in that program.
However, I am not able to do that.

Attached is a part of the Pivot Chart in which the debris 93.4% is showing
up in red color automatically.

DEBRIS 93.4%
DELAMINATION 100.0%
DENTS AND LUMPS 91.8%
FLATNESS 100.0%
FORKLIFT DAMAGE 99.5%
LENGTH 97.0%
LINE DAMAGE 97.6%

Please let me know if you the answer to the query or if you need more
information.

Amol

(909) 997 7030