How to grab value of cell during conditional formatting?

Dash Python
2

@robswc Sadly there’s currently no way to natively use the value of a field in a formula to return a modified value to use on props. We are discussing the feasibility of adding formula support to the table but there’s no specific plans or timeline yet. Maybe it will look something like this:

{
  if: { column_id: 'temperature' },
  background_color: 'gradient(0, 100, {temperature}, blue, red)'
}

The best you can do for now with the props is define ranges with the appropriate colors and have each range represented by a conditional style. The more granular, the more gradient-like, but the more costly in terms of cpu / resources when rendering the table.

{
  if: { column_id: 'temperature', filter_query: '{temperature} ge 0 && {temperature} lt 10' },
  background_color: '#0000FF'
},
{
  if: { column_id: 'temperature', filter_query: '{temperature} ge 10 && {temperature} lt 20' },
  background_color: '#0000CC'
},
// ...

Related to Dash-table: Graded Color Scale (conditional formatting) slow