unixisbest
Technical User
- Jul 11, 2005
- 28
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.
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.
