Conditional Formatting with percentages

Options

Hello all!

I am wondering if there is a way to use the conditional formatting with percentages. For example, I have a report with inconsistent data in each column (some percentages, some just numbers). When I try to condition as greater than 90%, greater than .90, or greater than 90 it includes the full numbers as well instead of just the percentages

Thank you for any help you may be able to provide!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!