Cell color formula
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,A11)
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
|