Is it possible to apply Conditional Formatting with a formula?

10/31/19 Edited 12/09/19

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

Screen Shot 10-31-19 at 03.50 PM.PNG

Comments

Sign In or Register to comment.