Conditional Formatting in a pivot table based on 2 conditions.

[HOXIE]

Conditional Formatting in a pivot table based on 2 conditions.

I would appreciate any advice as to why this is not working in my pivot table.

Use a Formula to determine which cells to format
=AND($D1="SNF",$Z1="0")
ON $Z:$Z in This Pivot Table

Column D can only contain 2 values; either SNF or HCBS
Column Z can only contain 2 values; either 0 or 25

Thanks in advance for any expertise in this matter.

 

[HOXIE]

Conditional Formatting in a pivot table based on 2 conditions.

I would appreciate any advice as to why this is not working in my pivot table.

Use a Formula to determine which cells to format
=AND($D1="SNF",$Z1="0")
ON $Z:$Z in This Pivot Table

Column D can only contain 2 values; either SNF or HCBS
Column Z can only contain 2 values; either 0 or 25

Thanks in advance for any expertise in this matter.

I got this t work with =IF($D12="HCBS",0,1)+IF(INT($Y12)=0,0,1)=0