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

Is is possible to format a cell based on one component of the RGB value inside of it. For example, let's say I have 3 cells - A1, A2, A3. In A1, I want the cell color to be the shade of red anywhere between 0 and 255 of the number in the cell (so if it is 128, it should be like half red). For that given cell, the other values will just be 0, 0 (so in this case, zero green and zero blue).

Is this possible?

share|improve this question
up vote 2 down vote accepted

You can mimic this in Excel 2007/2010 by using a formatting rule over the range in question:

  • Two-color scale
  • Minimum of type number with value 0 and color black (or white, your choice)
  • Maximum of type number with value 255 and color red
share|improve this answer
Yeah, that's pretty good! – Otaku Jun 10 '10 at 21:37

Your Answer


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