Conditional formatting - highlight cell value based on high, low, midpoint

[=Sum(guy)]

It seems like what I'm trying to do should be very simple, but I can't find a solution. I have a column with values that range in value between two (low and high) values on another sheet. I want the value with the format to be colored with a shade that ranges between the low and high values, i.e. green for low and red for high and if in the middle somewhere a shade between those two colors. The green - yellow - red color scale seems like the right option, but it appears that's supposed to be used to compare values of surrounding cells (which I don't care about). I'll try to explain below with an example.

Format column - value (expected color)
0 (green)
50 (yellow)
100 (red)
80 (light red)
25 (light green)
65 (orange)
etc.

Different sheet
Low value
0

High value
100

Any help would be much appreciated!

[protonLeah]

(How to) Upload a Workbook directly to the Forum
(please do not post pictures or links to worksheets)

• Click Advanced next to Quick Post button at the bottom right of the editor box.
• Scroll down until you see "Manage Attachments",
• Click the "Choose" button at the upper left (upload from your computer).
• Select your file, click "open", click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Close the Attachment Manager window.
• Click "Submit Reply"

Note: Please do not attach password protected workbooks/worksheets
Ensure to disable any Workbook Open/Autorun macros before attaching!