Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Change color of an Excel cell

Posted on 2013-06-11
2
Medium Priority
?
453 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 (Microsoft MVP / EE MVE) earned 2000 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
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…

564 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