Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Designating color in one cell based on data entered in another cel
I need a way (formula, format, etc) for the background color in one cell to
be determined by the data entered in another cell. For example: Cell C6 will have a number manually entered. Cell D6 will have a single letter manually entered into it. Based on the letter entered in D6, I want the background color in cell C6 to be a certain color. If the letter in D6 is P then the background in C6 needs to be green. If the letter in D6 is I, then the background needs to be red. I have 7 letters that will be entered into cell D6 that will need to determine 7 different background colors for cell C6. How can I make this happen using excel 2003? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Select correct worksheet based on data entered into a cell | Excel Worksheet Functions | |||
How to sum data based on font or cell color? | Excel Worksheet Functions | |||
How do I change cell color based upon data range within the cell? | Excel Worksheet Functions | |||
Changing chart color based on number entered | Charts and Charting in Excel | |||
How do I change fill color in excel based on data in the cell | Excel Worksheet Functions |