Solved

Change color of an Excel cell

Posted on 2013-06-11
2
426 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering 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

Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

856 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