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