Conditional Coloring Improvements - Based on Other Values, etc

The Conditional Coloring for Cells (Row/Col) is currently pretty weak in terms of capabilities. The following would be nice improvements:

  • Ability to color based on another column’s value, rather than fixed values
  • Ability to use Formula math in the value box as well (ie. If value is more than ({Other Col 1} + {Other Col 2})

Agreed. This will make scorecards more effective. Set the value in a Target column, then add a new column for each week’s progress and conditionally format the cell green if it meets or exceeds the Target column and red if it doesn’t. In it’s current form, if you select the Cell option in conditional coloring, it actually applies the logic to the entire column.