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.
Bookmarks