Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a table comprised of % values where a higher one is something bad whereas a lower one is good.

Using the quick analysis option "Color Scale" I get at a glance which is better or worse but the coloring scheme goes from red to green, red being lower values and green being higher ones.

Is there a way of inverting it? So that lower values go to green and higher go to red?

share|improve this question
up vote 2 down vote accepted

Quick analysis only helps to quickly create a visualisation. After that, you can select the formatted data and use the Conditional formatting dialog to select another color scale.

share|improve this answer
I see! I was looking all over for a place to change the formatting and couldn't find it. Thank you very much. – James Russell Jun 9 '13 at 22:49

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.