Changing Cell Background Color based on data from another cell

  • Thread starter Thread starter Speedy
  • Start date Start date
S

Speedy

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
 
Select A1 and Format>Conditional Format>Formula is:

=B1<>""

Format to a pattern and OK your way out.


Gord Dibben MS Excel MVP
 
Back
Top