| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change the color of cell background based on a result | Excel Worksheet Functions | |||
| Changing a color in a cell based on the text in another cell | Excel Discussion (Misc queries) | |||
| Changing Cell Background Color Depending on the Number | Excel Discussion (Misc queries) | |||
| changing cell background color | Excel Worksheet Functions | |||
| Changing background color based on different cell | Excel Discussion (Misc queries) | |||
Linear Mode
