Conditional Formating Question

  • Thread starter Thread starter TyeJae
  • Start date Start date
T

TyeJae

Can I conditional format a certain cell based on a different cells
value, for example:

I have 3 different colors that show up in cell D7, but I have a value
in D8 already that I do not want to change, but I want the color of D8
to be the color that shows up in D7. So...

If D7 equals Green then I want the background of D8 to be Green as
well, but if D7 equals Red then D8's background would be Red, and so
on.

I don't know if I can solve this through conditional formatting or if
there is some VBA that would do this.

Any help?

Thanks,
TyeJae
 
TyeJae

use Formula is in cell D8 and use D7=whatever the conditions are in cell D7
to set the colours

Regards

Trevor
 
Hi
you could use the value of a different cell as condition. e.g. select
cell B1 and in the conditional format dialog enter the formula
=$A$1=10
- choose a format which will apply if cell A1 is 10
 
I expect that you aren't aware that the formula is based
on the active cell and the coloring based on the selection
when the formula is entered.

Conditional Formatting
http://www.mvps.org/dmcritchie/excel/condfmt.htm

D7: 'Red
D8: '(doesn't matter)

Select D7 & D8 -- D7 is the active cell
Format, Conditional Formatting
condition 1: Formula is: =$D$7="red"
condition 2: Formula is: =$D$7="green"
enter format for interior pattern color

Note these cells are above one another on two different
rows as the poster indicated. I think it would be more
common for the two cells to be on the same row.

See my condfmt.htm web page for more information.

When posting to newsgroups, which you have done, it
is a lot more friendly to use your first and last names,
regardless of whether you munge your email address.
My opinion is that you will get a lot more out of newsgroups
if you use your real email address -- but you should
have steps to filter email such as getting a free hotmail
address.


Soe said:
Hi,
I tried it by conditional formating, however, nothing happened.
How did you do it?
Click to expand...
 
Back
Top