excel - Find the address of a specific PivotItem -

i have value rowfield.name , value pivotitem.name in rowfields, want highlight specific cell. can't seem find way allows me loop through every visible rowfield.

ideally want this:

sub loopthroughpivotandfindvalue() dim pt pivottable, pi pivotitem, pf pivotfield  set pt = wb.pivottables("pivottableno1")  each pf in pt.pivotfields   each pi in pf.pivotitems     if pf.name = "test" , pi.name = "value"       'ideally here output of address within sheet     end if   next pi next pf end sub 

ultimately want color specific cells in pivot table cannot seem find way properly. there no index property aware of.

anyone idea?

without knowing pivottable looks like, can't answer exactly, can tell you're looking use getpivotdata method can name field , item you're looking , return range.

hope trick!!