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