Solved: Conditional Formatting by formula using absolutely ANY color

[mrbrownjeremy]

EDIT: I figured it out—see reply in next message

Is it correct that the below thread from 2022 contains the only way to also change the text color to something with more contrast for darker colors? Unfortunate if so.

@Paul_Danyliuk

P.S. Am I not Paul?

This requires black magic though: you need to take the control object of a Slider and mix in a few properties to turn it into a progress bar.

Here’s the single formula. Don’t forget to set column type to Progress Bar. This is a hacky trick that may break any moment (and can even break your doc) so use at your own risk:

ParseJSON(
  '{"o":'
  + Slider(thisRow.[Slider input])._Merge(
      Object(
        "value", thisRow.[Slider input],
        "properties", Object(
          "displayType", "Progress",
          "color", SwitchIf(
            thisRow.[Slider input] < 20, "Red",
            thisRow.[Slider input] < 50, "Orange",
            thisRow.[Slider input] < 80, "Yellow",
            "Green"
          )
        )
      )
    ) + ""
  + '}'
)._Deref_object("o")

Welcome to the Community, @Valentin_Serry!