Solved

Change color of an Excel cell

Posted on 2013-06-11
2
417 Views
Last Modified: 2013-06-14
I am running Office 2000 on a Windows 7 Pro pc fully patched.

My question:  I have a simple spreadsheet.  Cell A1 has a date in it.  The cell has no color.  If cell A10 has the letter A   in it, I want to change the color of cell A1 to a light blue.

1.)  What command do I put in Cell A1 to cause a color change?   I am not an Excel expert.  I have done some vb programming using Access 2000 so I understand functions.  To do what I want may involve writing a function.  

2.) if a function (or sub) is needed, please give me a detailed answer on what commands to put into the function or sub.

3.) I assume the function is called in cell A1.  How do I call the function and still have a date value in cell A1?   Or may be I call the function from some other cell??  I hope you can explain.

4.) I assume the colors have numbers.  How do I determine the color number  I need for light blue?

Thank you for your help
0
Comment
Question by:donpick
2 Comments
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst earned 500 total points
ID: 39239888
Hello,

I don't have Excel 2000 anymore, but I think the steps are the same in 2003:

Select cell A1

Click Format > Conditional formatting. In the dialog you will see three drop-downs. Change the first to "Formula is".

Enter this formula into the formula box next to the drop down:

=$A$10="a"

conditional formatting with formula in 2003
Select a format with the Format button and click OK on all dialogs.


cheers, teylyn
0
 

Author Closing Comment

by:donpick
ID: 39248879
This works well, thank you for your prompt reply
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now