Designating color in one cell based on data entered in another cel
You need VBA code or Excel 2007.
"Diogie" wrote:
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?
|