"Score" column concept

I would love to see a “score” column that would allow a user to insert a number that visually changes based on preset ranges. For instance:

  • 0 - 80% = red
  • 81 - 99% = yellow
  • 100% = green

The user would be able to set the range levels, add additional ranges, and select the colors. Even the number format: percentages or number with decimals.

I realize there is already a number option and conditional formatting, but I think visually, the score number should be a much larger and bolder format. Specifically, I am thinking of use cases for OKR scoring, grading, or just general progress on a task.

Here’s a mockup of what it could look like: