VBA- Cond. form with 2 pivot tables

[Minkowski]

hello everyone i have in 1 sheet 2 Pivot tables
i have created Ranges for the pivot data

one pivot has 0,1 only
i want one the other pivot to get lets say red if 0(in the other pivot)
orange if 1

Option Explicit


Private Sub Worksheet_Calculate()

    
    Range("Range2").Select
    Selection.FormatConditions.Delete
    Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlEqual, Formula1:="0"
    Selection.FormatConditions(1).Interior.ColorIndex = 3
    Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlEqual, Formula1:="=1"
    Selection.FormatConditions(2).Interior.ColorIndex = 36
End Sub

but this gets red,yellow in Range2 i want it in Range 1
is this possible?
thanks in advance!