Hey all,

Quick question: I have a list of names in column A. Some of these
names have an "X" next to them in column B. Is there a way to apply
condition formatting in the way of saying if there is an X in column
B, fill in a red color in the corresponding name in column A. For
example, A5 has Bill Davis in it, B5 has an X in it, therefore cell A5
would be color filled Red. I've tried conditional formatting but it
works only for the cell i want something done to and doesn't take into
consideration conditions for other cells.

Please help...thanks!

I don't see an easy way to do that (other than a circular conditional
format, which would be gross).

It is super simple with VBA. Is that allowed?

Chris

On Mar 7, 11:23*am, " wrote:
Hey all,

Quick question: I have a list of names in column A. Some of these
names have an "X" next to them in column B. Is there a way to apply
condition formatting in the way of saying if there is an X in column
B, fill in a red color in the corresponding name in column A. For
example, A5 has Bill Davis in it, B5 has an X in it, therefore cell A5
would be color filled Red. I've tried conditional formatting but it
works only for the cell i want something done to and doesn't take into
consideration conditions for other cells.

Please help...thanks!

Select the entire Column A, go to the Conditional Formatting dialog and
select "Formula Is" from the first drop down and use this formula in the
second field...

=B1="x"

click the Format button and choose your red format and then OK your way back
to the sheet. Put an X in a cell in Column B and the corresponding cell in
Column A will be filled in with the color you selected.

Rick


wrote in message
...
Hey all,

Quick question: I have a list of names in column A. Some of these
names have an "X" next to them in column B. Is there a way to apply
condition formatting in the way of saying if there is an X in column
B, fill in a red color in the corresponding name in column A. For
example, A5 has Bill Davis in it, B5 has an X in it, therefore cell A5
would be color filled Red. I've tried conditional formatting but it
works only for the cell i want something done to and doesn't take into
consideration conditions for other cells.

Please help...thanks!

Select the Cell A1 and bring up the conditional formatting dialog. Switch
from Cell Value is to Formula is. Add this formula
=TRIM(UPPER(B1))="X"
and create your red format

This formula will work for both upper and lower case X and it will work even
if the X is padded with blank spaces.
--
HTH...

Jim Thomlinson


" wrote:

Hey all,

Quick question: I have a list of names in column A. Some of these
names have an "X" next to them in column B. Is there a way to apply
condition formatting in the way of saying if there is an X in column
B, fill in a red color in the corresponding name in column A. For
example, A5 has Bill Davis in it, B5 has an X in it, therefore cell A5
would be color filled Red. I've tried conditional formatting but it
works only for the cell i want something done to and doesn't take into
consideration conditions for other cells.

Please help...thanks!

And that's why MVPs rule the world :)

On Mar 7, 11:44*am, "Rick Rothstein \(MVP - VB\)"
wrote:
Select the entire Column A, go to the Conditional Formatting dialog and
select "Formula Is" from the first drop down and use this formula in the
second field...

=B1="x"

click the Format button and choose your red format and then OK your way back
to the sheet. Put an X in a cell in Column B and the corresponding cell in
Column A will be filled in with the color you selected.

Rick

wrote in message

...



Hey all,

Quick question: I have a list of names in column A. Some of these
names have an "X" next to them in column B. Is there a way to apply
condition formatting in the way of saying if there is an X in column
B, fill in a red color in the corresponding name in column A. For
example, A5 has Bill Davis in it, B5 has an X in it, therefore cell A5
would be color filled Red. I've tried conditional formatting but it
works only for the cell i want something done to and doesn't take into
consideration conditions for other cells.

Please help...thanks!- Hide quoted text -

- Show quoted text -

On Mar 7, 11:47*am, cht13er wrote:
And that's why MVPs rule the world :)

On Mar 7, 11:44*am, "Rick Rothstein \(MVP - VB\)"



wrote:
Select the entire Column A, go to the Conditional Formatting dialog and
select "Formula Is" from the first drop down and use this formula in the
second field...

=B1="x"

click the Format button and choose your red format and then OK your way back
to the sheet. Put an X in a cell in Column B and the corresponding cell in
Column A will be filled in with the color you selected.

Rick

wrote in message

...

Hey all,

Quick question: I have a list of names in column A. Some of these
names have an "X" next to them in column B. Is there a way to apply
condition formatting in the way of saying if there is an X in column
B, fill in a red color in the corresponding name in column A. For
example, A5 has Bill Davis in it, B5 has an X in it, therefore cell A5
would be color filled Red. I've tried conditional formatting but it
works only for the cell i want something done to and doesn't take into
consideration conditions for other cells.

Please help...thanks!- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

YOU GUYS ARE THE BEST! Thank you kindly!