Highlight the cells that make up the sumif forumla

[teric]

Good Day All,

I did a sum if formula with partial matching for a list of Shipment IDs and its costs. It returns the total cost of all the shipment IDs that match. Now I am trying to highlight or identify in any way those figures that have been used to get the results of the formula. This is to ensure that all shipments are accounted for and those that have not can be found.

This is my formula used:

=SUMIF($A$2:$A$12,"*"&A15&"*", $B$2:$B$12)

Any help would be greatly appreciated.

Thank you,
Teri

[Fluff13]

Select B2:B12 & use conditional formatting with this formula
=ISNUMBER(SEARCH(A$15,A2))

[teric]

Thank you so much.
It works perfectly, but just for one of the sumifs.

This is an example of the spreadsheet I'm using :
Capture-excel.PNG

I'm trying to highlight all cells which were used to get those results from the formula.
I'm using sum if partial match for multiple shipments and getting the values of those.

[Fluff13]

You can nest the formula like
=OR(ISNUMBER(SEARCH(A$15,A2)),ISNUMBER(SEARCH(A$16,A2)))
for each value you want to check

[teric]

Works great! Been searching how this can be done for almost a week!

Thank you so much!

[Fluff13]

Glad to help & thanks for the feedback