i suspect that he has sic CFs --- there are gaps in his numerical ranges

"Pecoflyer" wrote:


Dani Lima;221278 Wrote:
I want a macro to change the color of a cel acording to its value. It
cant be
done with conditional formating cause I have 4 ranges of values.

from 0% to 80% = black and white font
from 81% to 84% = red with white font
from 89% to 92% = yellow with black font
from 93% to 100% = green with white font

Someone can helpme??

Why not use CF?

Just make your default format one of the four ( say the first from 0%
to 80% = black and white font) and then apply the three other CF's
you will then only have conditions for

from 81% to 84% = red with white font
from 89% to 92% = yellow with black font
from 93% to 100% = green with white font

HTH


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload -faster and better answers

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=60981