Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using OR to evaluate TEXT
Awesome... It is always the simple fixes that I seem to miss. Thanks
for your time Dave!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a function that will evaluate a text string in a cell? | Excel Worksheet Functions | |||
Evaluate text string as a function | Excel Discussion (Misc queries) | |||
converting constant/text to formula and evaluate it | Excel Programming | |||
VBA Function to evaluate hlookup text string as formula | Excel Programming | |||
How to evaluate a text expression as formula ? | Excel Programming |