Change Cell color with formula or vb

[unixisbest]

Hi All,
I need formula or vb to change specific cells color.
For example if value of a cell is beetween 3 and 6 ,color should be red and if value is bigger than 6 color should be green . I can make this easily by using conditional formating from excel menu but there are only three condition to apply. But i need more. So to me Vb should do this.

For instance something like this pseudocode:

If A1 contains 20.1 then
change color of A1 to green
endif

I'm using Excell 2003.

Thanks for any help.

 

[Gavona]

Have a look at:
thread707-1108039
thread68-1103874


Gavin