Conditional formatting, multiple values

[amthyst826]

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.

[6StringJazzer]

One method is to go to Conditional Formatting, then Manage Rules. Use New Rule three times, once for each name you want to match. Because you want to format a cell other than the one with the value you are checking, you should use "Use a formula to determine which cells to format" and it will reference $A1. Then you can copy the formatting to other cells and the relative part of the reference will be copied correctly, just as when you copy formulas with relative references to other cells.

[jasoncw]

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

[Bigadz]

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?

[Fotis1991]

Hi and welcome to the Forum.

Unfortunately, your post is againstt rule No 2 of the forum, that says:

..2. Don't post a question in the thread of another member -- start your own. If you feel it's particularly relevant, provide a link to the other thread.

Pls, spend some minutes and start your own Thread and be sure, that you will find your solution.