conditional formating

[biglb79]

Is there a way I could setup conditional formatting for company names in cells A6:A493 to turn green if they are listed in any of the names in cells D6:D120?

Thanks

 

[philwojo]

You could try this, highlight the range of Cells you want to turn green, then click on CF (Conditional Formatting) and add a new formula.

Put this in:

=COUNTIF($D$6:$D$120,A61)>0

Then set your formatting to what you want to happen.

See if that works.

 

[biglb79]

that worked! thanks so much

 

[philwojo]

Glad to help.

 

[biglb79]

or maybe I spoke too quickly because I saw company names highlighted. it doesn't look like it worked correctly

 

[philwojo]

What do you mean by "company names highlighted"?

Can you be more descriptive about what is wrong?

Based on what you stated the formula works for me but I may have misunderstood what you needed.

 

[biglb79]

perhaps I'm doing it wrong on my end too, but I have a long list of companies for the quarter. they are the ones in cells A6:A493 and I highlighted all of those before clicking on conditional formatting to add the new rule. D6:D120 are the companies I want highlighted in column A if they are listed in column D. It highlighted some companies that aren't in column D when I put in the formula above

 

[Joe4]

It sounds like you do not have the formulas aligned with the range you are selecting.

Note the formula he gave you:

=COUNTIF($D$6:$D$120,A61)>0

That would work for an entry in cell A61.

The way to do this for multiple cells is to first select all the cells you want to apply this Conditional Formatting too.
Then, enter the formula as it pertains to the very first cell in your selection.
If you use absolute/relative referencing correctly, Excel will automatically adjust it for all other cells.

So, if you are looking to apply this to A6:A493, first select that exact range.
Then, enter this CF formula:

=COUNTIF($D$6:$D$120,[COLOR=#ff0000]A6[/COLOR])>0

and choose your formatting option.

 

[philwojo]

I see a typo in my formula, it says A61, it should just be A6.

Try and update it and then see if it works.

 

[biglb79]

ah ha, that worked now

thanks again for your help