It would be nice if we could use calculated colors on conditional formatting.
Just came upon a need where this would be a nice to have. I simply want to change the color of a button based on a status value. Rather than having to create a conditional formatting rule for each possible status, i'd rather store the status color as RGB or Hex in the status table, and then reference the color value through SQL or a relationship to set the correct color.
Perhaps this isn't even specific to conditional formatting, but rather the ability to just set a color based on a calculation.
Just searched the existing Product ideas and found this one... and it only had 1 vote.
Allow Layout Formatting To Access The Calc Engine
Retrieving data ...