Function to change cell color

A

ali

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 ^_^!!
 
G

Gav123

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.
 
Top