Conditional Formatting with percentages
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

You would need to include an argument to look at the number being both grater than .9 and also less than or equal to 1.

How would I exclude values that are "1"? Its highlighting the 100% and the "1" values

Unfortunately that is going to require manual intervention where you insert a helper checkbox column and manually check the box on rows that contain an actual percentage. You would then incorporate this into the same conditional formatting rule to only highlight cells that are between .9 and 1 and have the box checked.
Help Article Resources
Categories
Check out the Formula Handbook template!