It's mostly done, but I wanted to make it so the "desired shim" values had a cell color based on if it the current shim is in the desired range. I'm not good enough with excel to figure that much out. Would love any help if anyone is able to do this!

 

Some conditional formatting should help.

The two columns min and max tell you whether your shim is in range. Anything red is out of range.