Function to change cell color

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ali - 12 Sep 2007 08:32 GMT

Is there any function to change the cell color ?

for example:

if Cell A1 is "001" it should be "Green"

if Cell A1 is "002", it should be "Pink"

something like that....

thank you so much , experts ^_^!!

Signature

Allen Phailat Wongakanit

Reply to this Message

Gav123 - 12 Sep 2007 09:14 GMT

Hi Ali,

What you are describing sounds like Conditional Formatting...

select your range to be formatted

Format>Conditional Formating.

And set your conditional formatting to..

Cell Value Is>Equal to>001 Format as Green

Click Add and set your 2nd condition

You can have 3 conditions set like this with XL2003

Regards,

Gav.

> Is there any function to change the cell color ?
>
[quoted text clipped - 7 lines]
>
> thank you so much , experts ^_^!!

Reply to this Message