Chaging the color of a cell acording to its value
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
"Dani Lima" 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??
|