Hello All,

I have just started with VBA and am having trouble with a basic problem of formatting a cells appearance based upon the value of a cell. For example I have the number 1 to 10 in a list and would like to format individual cells yellow if they have the value 5 and above, Once I have the VBA code basics I should be able to apply this to numerous sheets.

Any help would be much appreciated.

Jaso