Conditional Formatting with Percentages

I'm trying to conditional format on a column of percentages from red to green. However, sometimes the percentages go over 100% and since the conditional format is across all values in the column, often a 99% will look red because it's so far off from the highest value in the column.

 

How do I get it to conditional format red to green from specifically 0% to 100%? 

Reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like Follow
  • 2 mths agoLast active
  • 53Views
  • 1 Following

Create A New Discussion

Share your thoughts