Q: automaticly changing colours from a cel by visual basic

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Marco Polo - 07 Mar 2007 07:18 GMT

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

Reply to this Message

Sysyphus - 07 Mar 2007 08:28 GMT

> Hello, I have an worksheet where I want to change the colour by de value
> of
[quoted text clipped - 5 lines]
> 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

Reply to this Message

Don Guillett - 07 Mar 2007 13:13 GMT

Format>conditional Formatting>pretty easy

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

> Hello, I have an worksheet where I want to change the colour by de value
> of
[quoted text clipped - 7 lines]
>
> Remo

Reply to this Message