Formatting based on a condition
 

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!

Formatting based on a condition
 

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!

Formatting based on a condition
 

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!

Formatting based on a condition
 

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!

Formatting based on a condition
 

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 -

Formatting based on a condition
 

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!