Is it possible to apply Conditional Formatting with a formula?

pbfalk
pbfalk
edited 12/09/19 in Formulas and Functions

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!