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

 

[Patrick Molloy]

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