I have many sheets in my workbook out of which one is "clar" and one is "SEO"
Seo sheet have 5000 rows of data and column "A" has names of people
When i paste a name or click F2 and paste the name or type the name manually i want thuis name checked in all cells in Column "A" in "SEO" sheet and at same time check if the name is available in same sheet "Clar" column "A"
If in Clar sheet then color "Yellow" and if in "SEO" sheet color "Blue"
If name is new then no color
Can anyone help with a code.