Conditional Formatting in Pivot Tabel

[Bernaar]

Hello

I would like to see certain cells turn red or green based on the number in the cell compared to another number.
Attached you can find the Excel sheet.

The purpose is the following: If there are any certified resellers that have the status NOK, it should turn red, otherwise green

Type	BE	FR	NL	Grand Total
Certified Reseller	3	25	5	33
NOK		25	5	30
OK	3			3

This is a pivot tabel in which:

• Certified Reseller is the "type"
• OK/NOK is the "status"
• BE, FR, NL ... are the countries
• the values in the pivot table are the count of the "Names"

Thanks!

Tim

[Ace_XL]

In CF use

=AND($A5="NOK",$A4="Certified Reseller")

Apply to: All cells showing "Count of NAAM" values

Format red