Formula to see if name on one sheet exist in another sheet

[Jnb99]

Hi Guys,

Simple problem but I cant get anything to work

I have 2 Sheets: "Customer Master" and "Monthly call plan".

Customer master is updated weekly with names added. So to go through each one every time is a timeous process. Is there a formula that I can use that will take a name in customer master sheet and look if it exist in call plan sheet?

Thanks

 

[Jamie McMillan]

Hello,

Just use a formula in conditional formatting. On Sheet2 apply the conditional formatting to cell A1. Then use Format Painter to copy the formatting to the other cells A1:A23 in the formula.

=COUNTIF(Sheet1!$A$1:$A$23,A1)

Jamie