conditional format

[daveturner80]

I have a worksheet with members names in column A.
I also have a formula in column U which I want to compare the name in column a to column u and if they are a match, I would like to fill the cell in column a with a color. I would also like to keep the cell in column as the default color if it is no match.
What do I have to do to get this done. I am using office 2010.
Any help would be appreciated.
Thanks,
Dave

 

[cgcamal]

Hi Dave,

Do this:

1-) Select range in column A:
2-) Select conditional formatting;
3-) Choose "New Rule"
4-) Go to last option and select "Use a formula..."
5-) Insert as formula =COUNTIF($U$1:$U$10,A1). (Assuming range in U is from U1 to U10).
6-) Select the color.
7-) Click Ok, then click Apply.

* Be sure in option "applies to" is correctly set range the range in A.

Hope this helps.

Regards

 

[daveturner80]

That did the trick and all the cells I needed are color coded.
Thanks for your quick response.
Dave