So I am new to Excel VBA, and coding in general, so I am learning a lot on my own for a hobby. So please be patient with me as I may not explain myself well.

I am making a userform to help fill in information for creating a vessel for a TTRPG. I’ve cobbled together a code for multiple userforms that lets you pick a bunch of options and am stuck on the last userform. The last form has you place equipment purchased and determine the number of them placed in that position. I am using comboboxes, to select the equipment type, linked with textboxes, to fill in a quantity. I also have a Private Sub ‘Name’Sum() for counting all textboxes with similar comboboxes names to fill a total to a cell to check for “Over” quantity. The sheet then checks with a conditional format to see if that cell exceeds a previously decided number (variable) and changes the color of the cell. I’ve been trying to figure out how to have any cells with the “offending” value to hightlight with the same number, to indicate that adjustments are needed.

I’ve tried If funtions and other solutions for “similar” requests, but have been unsuccessful. I’m not certain if this is a problem of me finsing the right solutions, or if its my near Frankenstein code biting me in the rear end.
If there are other places online that would be better to ask this question, please inform me. Help appreciated.
I’m honestly not certain on which parts of my code to provide to aid since I have a lot going on at this point.