I appreciate your help!
So the code I posted does not work in the slightest.
I was unsure of the method needed to run a For Each that would allow my For loop to work for each sheet (not every sheet).
Let me make this clearer. The document has 8 sheets. Some are for instructions, some are notes, but the three sheets that need conditional formatting are:
Resources by Commodity, Resource by Company, Resource by Country
I need to take values entered into cells on my formatting sheet, and use those values as inputs to answer FormatConditions concerning a range for another sheet.
I'm realizing more and more I have no idea how to do this.
I'm really starting to confuse myself.