Solved

Change color of an Excel cell

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

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

749 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