View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tbal[_2_] Tbal[_2_] is offline
external usenet poster
 
Posts: 1
Default Can a pivot table function like data filter?


Just wanted to let everyone know that I found the answer. It is to use
conditional formatting. This will enable the user to view the selected
option (though not the drop-down arrow) in a color/format of my choice.
I hope this answer helps others who are looking for similar solutions!


--
Tbal
------------------------------------------------------------------------
Tbal's Profile: http://www.excelforum.com/member.php...o&userid=25317
View this thread: http://www.excelforum.com/showthread...hreadid=387971