I have a spread sheet where Cell X11 has conditional formatting allowing it
to be Green, Yellow or Red.

I would like Cell A1 to change color and always be the same color as Cell X11.

Is there a function that does this?

Darrell

Stefi:

Thank you, that was quite simple. (I hope I remember it the next time I need
this application!!!)

Darrell

"Stefi" wrote:

Apply conditional formatting for A1 as follows:

Select formula as condition (instead of cell value)
1st condition: =$X$11="C" choose green
2nd condition: =$X$11="I" choose yellow
3rd condition: =$X$11="X" choose red

Regards,
Stefi



€žDr. Darrell€� ezt Ã*rta:

Stefi:

Thanks for the reply.

That would work if I wanted to have the same text in Cell A1 and Cell X11,
but I don't.

I want to type a date into Cell A1 and have the color the same as Cell X11.

I have 3 conditions:

If Cell X11="C", Green
If Cell X11="I", Yellow
If Cell X11="X", Red

Darrell

"Stefi" wrote:

I should apply the same conditional formatting criterium for A1 as for X11.
If you post the criterium, I'll try to extend it to cell A1.

Regards,
Stefi


€žDr. Darrell€� ezt Ã*rta:

I have a spread sheet where Cell X11 has conditional formatting allowing it
to be Green, Yellow or Red.

I would like Cell A1 to change color and always be the same color as Cell X11.

Is there a function that does this?

Darrell

I should apply the same conditional formatting criterium for A1 as for X11.
If you post the criterium, I'll try to extend it to cell A1.

Regards,
Stefi


€žDr. Darrell€� ezt Ã*rta:

I have a spread sheet where Cell X11 has conditional formatting allowing it
to be Green, Yellow or Red.

I would like Cell A1 to change color and always be the same color as Cell X11.

Is there a function that does this?

Darrell

Apply conditional formatting for A1 as follows:

Select formula as condition (instead of cell value)
1st condition: =$X$11="C" choose green
2nd condition: =$X$11="I" choose yellow
3rd condition: =$X$11="X" choose red

Regards,
Stefi



€žDr. Darrell€� ezt Ã*rta:

Stefi:

Thanks for the reply.

That would work if I wanted to have the same text in Cell A1 and Cell X11,
but I don't.

I want to type a date into Cell A1 and have the color the same as Cell X11.

I have 3 conditions:

If Cell X11="C", Green
If Cell X11="I", Yellow
If Cell X11="X", Red

Darrell

"Stefi" wrote:

I should apply the same conditional formatting criterium for A1 as for X11.
If you post the criterium, I'll try to extend it to cell A1.

Regards,
Stefi


€žDr. Darrell€� ezt Ã*rta:

I have a spread sheet where Cell X11 has conditional formatting allowing it
to be Green, Yellow or Red.

I would like Cell A1 to change color and always be the same color as Cell X11.

Is there a function that does this?

Darrell

You are welcome! Thanks for the feedback!
Stefi


€žDr. Darrell€� ezt Ã*rta:

Stefi:

Thank you, that was quite simple. (I hope I remember it the next time I need
this application!!!)

Darrell

"Stefi" wrote:

Apply conditional formatting for A1 as follows:

Select formula as condition (instead of cell value)
1st condition: =$X$11="C" choose green
2nd condition: =$X$11="I" choose yellow
3rd condition: =$X$11="X" choose red

Regards,
Stefi



€žDr. Darrell€� ezt Ã*rta:

Stefi:

Thanks for the reply.

That would work if I wanted to have the same text in Cell A1 and Cell X11,
but I don't.

I want to type a date into Cell A1 and have the color the same as Cell X11.

I have 3 conditions:

If Cell X11="C", Green
If Cell X11="I", Yellow
If Cell X11="X", Red

Darrell

"Stefi" wrote:

I should apply the same conditional formatting criterium for A1 as for X11.
If you post the criterium, I'll try to extend it to cell A1.

Regards,
Stefi


€žDr. Darrell€� ezt Ã*rta:

I have a spread sheet where Cell X11 has conditional formatting allowing it
to be Green, Yellow or Red.

I would like Cell A1 to change color and always be the same color as Cell X11.

Is there a function that does this?

Darrell