Function to change cell color

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 ^_^!!
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function for summing or counting cells based on a specified fill color 2
How to extract separated text by many commas in Excel? 0
change the color of cell background based on a result 2
Conditional formatting excel 2003 1
Comparison of columns using Conditional Formatting 3
Changing Color of the Cell under Certain Conditions 8
Conditional formatting on 2nd cell 5
How do I test a specific color in 2003? 1

Back
Top