Conditional Formatting with percentages

Kaitlyn.kemp

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!

Paul Newcome

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.

Kaitlyn.kemp

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

Paul Newcome

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.