View Single Post
  #1   Report Post  
jimplace jimplace is offline
Junior Member
 
Posts: 1
Question What can be done with highlighted cells?

When I sort a list of product numbers appearing on invoices I identify a certain product number by highlighting the cell in yellow. My task if to find all invoices where the identified product number appears and all product numbers appearing on those invoices. Currently I sort the list by invoice number and manually identify the invoices that contain highlighted product numbers. Do the highlighted cells have a special value that would allow me to identify all product numbers appearing only on the invoices that have a highlighted cell?