Chaging the color of a cell acording to its value

[Dani Lima]

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??

 

[Patrick Molloy]

something like ....

SELECT CASE value
CASE <80
clr = 1
bck=2
CASE <84
clr = 1
bck = 3
etc
END SELECT

with target
..forecolor = clr
..interior.coplor = bck
end with

 

[Pecoflyer]

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

 

[Patrick Molloy]

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