Basically that's what the formulas I gave you do:
#1: anything greater than 0 and less than 100 = pink
#2: anything 100% = bright red
optional #3 (or default) would be 0 = white.

If you need 100 different shades of Red, there are only 2 ways to attack it:
In Excel 2007 you may have pretty much unlimited conditional formatting
(limited by memory) - but you'll need a pretty sharp eye to distinguish 100
shades of red to set up the formulas?

In any previous version of Excel you are limited to a max of 3 conditional
formats and to get 100 options, you would have to resort to Visual Basic.

So, is what you really want 100 different shades of red/colors for 100
different values in A#; 1 for each percentage point from 1 to 100, plus white
for 0%?


"Scafidel" wrote:

Thanks for quick response. I am only getting two colors, though. 100% is
red as I wanted, but anything less is the same light pink (the color I copied
out of Paint).
Lafayette, LA


"JLatham" wrote:

Select your entire range from B1 down to B# and then use Format | Conditional
Format from the menu.
For the first condition choose:
Formula Is and then type in =AND(A10,A1<1)
and set your format for the lighter shade of red you want.

Then choose [Add] to begin a second condition and again choose Formula Is
and for the formula portion, type this in
=A1=1
and again choose [Format...] to set bright red for the cell shading.

You don't need one for 0, since the default shade is unshaded/white
appearing. But if you do have them shaded something other than
uncolored/white, then use [Add] to set a 3rd condition. Once more you need
Formula Is and this time the formula will be
=A1=0
and set format to white shading.

Excel will adjust the addresses in each of the B# cells automatically for
you.

"Scafidel" wrote:

I would like a formula to change colors in cells B1-BX based on the values of
cells A1-AX, which are percentages from 0% to 100%. So, if A5=100%, B5 would
be absolute Red. If A6=99%, B6 would be just a little less red and if
A94=0%, B94 would be white.
Thanks
Lafayette, LA