Color Range Based On Number Range

Originally Posted by ajocius

I don't know if this will require VBA, but I'll give this forum a shot first. I have a range of numbers, at 0.0, 0.1, 0.2 to 1.0. I have a row of cells that will one of the previous 11 numbers in it. My problem is, how do I assign a different color based on the 11 numbers. So 0.0 would be red, 0.1 would be almost yellow etc until 1.0 would be green. If a cell doesn't have these numbers it will be blank. Blank cells will have no color. Does this type of problem require the use of VBA or can I do it without programming?

Tony

Hi,

On your worksheet, if you rightmouse the tab and select 'View Code' and paste

Please Login or Register  to view this content.

into there that should work for you.

You can make multiple copies of the 2 blue lines to add more selected amounts and more colours.

hth
---