Format a pivot table based on values of a pivot column

[chytechplus]

Good day guys, please I need your urgent help. Lets say i have a pivot table diplaying Student performance in 3 subjects ( Biology, English and Math). If each subject have different pass mark, how do i show a conditional formatting for these values? I would like to show GREEN if value is greater than or equal to 80% in biology and red if its less than, Then GREEN if value is >= 95% in English and Red if its less than. And finally show GREEN if value is >=85% in Maths and RED if its less than.

Please help me as not sure how to achieve this in the same pivot table, maybe we need a vba. See below Pivot able image and file is also attached. Many thanks in anticipaiton.

pivot table.png

[rorya]

You can apply conditional formatting to pivot tables as you can to regular ranges.

[chytechplus]

Thanks @Roya, can you please help out using the sample file I provided? I would really appreciate....

[rorya]

Afraid not. Given the current state of the forum and its malware issues, I won't download anything. I also happen to be on a phone at the moment as the forum is blocked by our Web filter for the same reasons.

[chytechplus]

Ok, I understand. Can you please provide steps using the examples I described above ? Many thank for your answer. Am I suppose to use a VBA? Please I need help.

[rorya]

See http://www.contextures.com/excelpivo...nalformat.html