View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Alan Alan is offline
external usenet poster
 
Posts: 492
Default 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