Automatic color scale conditional formatting for a column

I want to apply conditional formatting to a date column in a SharePoint list, similar to the color scale feature in Excel.

The formatting should automatically assign colors (e.g., shades of green) based on the relative position of each date within the range of dates in the column.

This means the colors should dynamically adjust without hardcoding specific date ranges or values, reflecting the closeness of each date to the minimum and maximum dates in the column.

I've read many other questions (including these) but haven't found examples that don't require hardcoded values.

• Conditional formatting based on date to expire
• Conditional Formatting Column using JSON
• Conditional formatting based on number of days to due date