Looking for workaround to achieve relative cell reference with 3-color scale conditioning formatting

This is literally my first Reddit post. Is there any work around, other than a macro, to use the 3-color scale conditional formatting in excel with the midpoint set as a relative cell reference? The minimum and maximum are hard numbers but I need the midpoint to reference a calculated value in a different cell and have that recalculated for each row? It’s a massive spreadsheet so I am trying to avoid having to manually change cell references for the mid point in each row. Hope that makes sense. Any help is greatly appreciated.