Changing Cell Background Color based on data from another cell
 

I would like to change the background color of one cell (A1) based on the
contents of another cell (B1). Cell A1 already has data in it and if cell B1
has data input into it, how can I get the background color in cell A1 to
change.

I would appreciate any help you can give me.

App: Excel 2003

Changing Cell Background Color based on data from another cell
 

Conditional Formatting will do that,
http://www.cpearson.com/excel/cformatting.htm
Regards,
Alan.
"Speedy" wrote in message
...
I would like to change the background color of one cell (A1) based on the
contents of another cell (B1). Cell A1 already has data in it and if cell
B1
has data input into it, how can I get the background color in cell A1 to
change.

I would appreciate any help you can give me.

App: Excel 2003

Changing Cell Background Color based on data from another cell
 

Select A1 and FormatConditional FormatFormula is:

=B1<""

Format to a pattern and OK your way out.


Gord Dibben MS Excel MVP


On Mon, 16 Mar 2009 07:25:03 -0700, Speedy
wrote:

I would like to change the background color of one cell (A1) based on the
contents of another cell (B1). Cell A1 already has data in it and if cell B1
has data input into it, how can I get the background color in cell A1 to
change.

I would appreciate any help you can give me.

App: Excel 2003