Currently the conditional colouring feature doesn’t support “greater than”, “equal to”, “less than” qualifiers for the formula column. These options are available for the number column but not for the formula column. The formula column needs the same functionality because most of the time the value in the formula column ends up being a number anyways.
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Conditional coloring should allow you to compare the values of two columns | 3 | 744 | June 21, 2025 | |
| File column support for conditional coloring, filters and formulas, etc | 0 | 1713 | May 30, 2022 | |
| Conditional Formating of formula columns that use date formats | 0 | 2295 | March 8, 2022 | |
| Conditional Coloring Improvements - Based on Other Values, etc | 9 | 3494 | January 14, 2025 | |
| Formula column is not recognized as a number or date so cannot be used in other features (Conditional coloring or Automations) | 1 | 2378 | August 16, 2021 |