Q: automaticly changing colours from a cel by visual basic

[Marco Polo]

Hello, I have an worksheet where I want to change the colour by de value of
the number wich is in the cel.
Example, when a cel contains the number 1-5 the cel must be the colour red
but when it contains the numbers 6->5 (5-10) the cel must be having the
colour blue.

I wonder if i can be done by visual basic or in Excel itself.
Thanks in advance,

Remo

 

[Sysyphus]

Hello, I have an worksheet where I want to change the colour by de value
of
the number wich is in the cel.
Example, when a cel contains the number 1-5 the cel must be the colour red
but when it contains the numbers 6->5 (5-10) the cel must be having the
colour blue.

I wonder if i can be done by visual basic or in Excel itself.
Thanks in advance,

You need 'Conditional Formatting'.

see: http://www.cpearson.com/excel/cformatting.htm

 

[Don Guillett]

Format>conditional Formatting>pretty easy