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!