Hi,
Can anyone show me how to change a cells background colour using vba.
I want to be able to loop through a give range of values and alter the background colour depending on the percentage value in that cell:
eg.
1 - 25 = green background
26 - 50 = blue background
51 - 75 = red background
76 - 100 = purple background
100+ = .....
Cheers
Don
Can anyone show me how to change a cells background colour using vba.
I want to be able to loop through a give range of values and alter the background colour depending on the percentage value in that cell:
eg.
1 - 25 = green background
26 - 50 = blue background
51 - 75 = red background
76 - 100 = purple background
100+ = .....
Cheers
Don