Changing Cell Background Color based on data from another cell

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
 
G

Gord Dibben

Select A1 and Format>Conditional Format>Formula is:

=B1<>""

Format to a pattern and OK your way out.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing row background from external program 0
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Cell data entering slow! 0
Change Color of cell 3
Excel does not accept text format! 0
Change background color of cell based on vlookup in cell 1
Printing from Word my Inserted Pictures colors are dull and lack color 0
VBA Coding Help for Beginner 0

Top