Using Formula(s) to Highlight Cells with Matching Values Across Workbooks

I am fairly new at the more advanced formulas within Excel, and as such, I am at a loss of if and/or how to proceed with an idea I have. Any assistance would be appreciated.

I track record boxes coming and going from storage using a spreadsheet that is within a workbook of sheets that break down the contents list of each box. Attached is a highly simplified sample of the workbook (a check out sheet and 1 content list sheet).

What I would like to do, is that when a box is checked out, I can tick a box that looks at a specific value "RF ID #" and then locates all cells that match that value in the whole workbook, and highlight it a color of my choice to give a visual indicator that the box is currently checked out. Then when the box is checked back into storage, I can un-tick the box that then reverses the process.

I apologize if this is confusing. I appreciate any time and assistance that others can offer. Thank you.