Is it possible to apply Conditional Formatting with a formula?

Welcome to the New Smartsheet Online Community


You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.

Is it possible to apply Conditional Formatting with a formula?

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.