Conditional formatting, multiple values

I see how to set conditional formatting for one name, how do I set it for multiple values?

Column A contains one of three names: Teri, Linda, Evelyn (Each name is repeated, randomly, through the column)
Column B is a variety of Categorys (Some text, some numeric, all different)

Cell A2 = Teri, I want cells A2 and B2 to be Orange, Accent 6, Darker 50% Font and Orange, Accent 6, Lighter 80% Fill

A3 = Linda, I want cells A3 and B3 to be Dark Blue, Text 2, Darker 25% Font and Aqua, Accent 5, Lighter 80% Fill

A5 = Evelyn, I want cells A5 and B5 to be Olive Green, Accent 3, Darker 50% Font and Olive Green, Accent 3, Lighter 80% Fill

I would like to format both columns so that as we add entries, both columns will color code according to the name in column A.

Start by selecting all the data in columns A and B, being sure to start by selecting A2. Then add the below conditions (pay attention to the location of the '$'). This will add the conditional formatting to all of your data in both columns at once.

Format Condition 1 (formula):
=$A2="Teri" ... add your formats

Format Condition 2 (formula):
=$A2="Linda" ... add your formats

Format Condition 3 (formula):
=$A2="Evelyn" ... add your formats

HTH,
Jason

Hi all,

I too have a query about multiple conditional vaules, but this applies to the formula.

Say I want to check if the cells of two columns meet two conditions to apply the formatting to the corresponding cells of a third column:

If A1,A2,A3, etc is "not blank", & also if B1,B2,B3, etc have a value greater than 10. If both these conditions are met, I want to have the text of C1, C2, C3, etc turn White & the background of the Cell to turn Red.

How do I get both checks happening (if only one or the other case is true, I don't want anything to happen).

I've tried using:
=A1><""&B1>10

But this does not work.

I also need the Cells of the C column C1, C2, C3, etc to just have Bold Red Text if the corresponding "A cell" is "Blank" & the "B cell" is ">10"

I have multiple Conditional formatting rules to work, but can not seem to check for two rules applying at once.

Can anyone help me please?