Using OR to evaluate TEXT
 

Hey everyone... Probably a very simple fix, but I just can't seem to
figure it out on my own (kinda new to Excel).

I have a list of names, simple text, that I want to apply a condition
to. Basically as follows:

John
David
Mike
Harry
Brad

These names are in a validation drop down list in cell A1. In cell B1,
I would like to have some type of evaluation similar to the following:

If cell A1 is either Brad OR John, then color of cell B1 is red... for
every other name, color of the cell is blue.

I was trying to accomplish this through conditional formatting. Thanks
for any help anyone can provide!

Using OR to evaluate TEXT
 

Give the cell a nice blue color and override it with your conditional
formatting.

And use a conditional formatting formula of:
=OR(A1="john",A1="brad")
with a nice shade of red.

stacy wrote:

Hey everyone... Probably a very simple fix, but I just can't seem to
figure it out on my own (kinda new to Excel).

I have a list of names, simple text, that I want to apply a condition
to. Basically as follows:

John
David
Mike
Harry
Brad

These names are in a validation drop down list in cell A1. In cell B1,
I would like to have some type of evaluation similar to the following:

If cell A1 is either Brad OR John, then color of cell B1 is red... for
every other name, color of the cell is blue.

I was trying to accomplish this through conditional formatting. Thanks
for any help anyone can provide!

--

Dave Peterson

Using OR to evaluate TEXT
 

Awesome... It is always the simple fixes that I seem to miss. Thanks
for your time Dave!!