Conditional formatting, multiple values

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?