Sign in to submit new ideas and vote
Get Started

Conditional Formatting - Format based on comparison between cells not a Helper Cell

If I want to apply a conditional format to Column B on the proviso that Column B is greater than Column A, I must use a Helper Cell to determine if this is True or not.

Like Microsoft Excel does; by including the ability to specify a formula to ascertain whether a Format should be applied would be a lot cleaner than having to add additional columns into the Sheet.

I feel like the Conditional Formatting Tool is almost there, with the addition of a @[Column] to select the column, we could have some success

14 votes

Active · Last Updated