Is it possible to apply Conditional Formatting with a formula?

pbfalk

In Excel we have the ability to use custom formula for conditional formatting, is this possible in SS?

Please see screenshot below.  

I need to compare column values to the value at the top cell.  I can do this by adding more columns and formulas and then hide them, it would be cleaner if I can do with conditional formatting.

Thanks!

P

Andrée Starå

Hi,

Unfortunately, it's not possible at the moment, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment.

Helper columns are the way to go. 

I hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD