VBA Help with colour change based on numerical value of cell

[lah1980]

Hi,

I would be really grateful if someone were able to help me on a problem I have. This is that I would like to change the cell background depending on the numerical value of a cell within the range of cells from G04:G208. I would like to meet the following conditions:

If cell value is "<15" colour cell orange
If cell value "15-75" colour cell green
If cell value ">75" colour cell red
and If cell value contains text "-" colour cell blue.

I can't use conditional formating as I have more than 3 conditions and think I need to use VBA to achieve what I want to do but have never used this before and so would really appreciate any help which can be given.

Many thanks in advance,

[Kenneth Hobson]

Welcome to the forum!

Right click the sheet's tab and paste:

Please Login or Register  to view this content.