Solved

Change color of an Excel cell

Posted on 2013-06-11
2
440 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst (Microsoft MVP / EE MVE) 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: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

729 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