Hi Experts,

I recorded this macro but I can't seem to get it to work:

Sub Macro3()
'
' Macro3 Macro
'

'
Range("L3").Select
ActiveSheet.Range("$B$8:$J$709").AutoFilter Field:=1, Criteria1:=RGB(255, 0 _
, 0), Operator:=xlFilterFontColor
Range("L4").Select
ActiveSheet.Range("$B$8:$J$709").AutoFilter Field:=1, Criteria1:=RGB(0, 102 _
, 0), Operator:=xlFilterFontColor

End Sub


What I'm trying to do is update the Filter by Color option of my pivot table (conditionally formatted) by clicking a cell of the same color. So if I click L3 which is red - I would like the Filter by Color option of my pivot table to select all data highlighted in red.

Is this possible?

Thank you.