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

Richard Heath

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

Kreig M

I to am wanting to be able to utilize formula logic in a conditional format (in my case a SUM formula) to determine if the format rule should be applied or not. I do not like having to have a bunch of 'helper columns' to accomplish simple tasks like this.