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 | |
|---|---|---|---|---|
| File column support for conditional coloring, filters and formulas, etc | 0 | 1700 | May 30, 2022 | |
| Conditional Formatting Column | 25 | 13253 | November 4, 2024 | |
| Conditional coloring should allow you to compare the values of two columns | 1 | 696 | November 27, 2024 | |
| Conditional Coloring Improvements - Based on Other Values, etc | 8 | 3389 | November 24, 2024 | |
| How to apply coloring to cells that meet your defined criteria (based on value) | 4 | 5586 | February 14, 2021 |