Hi all need help setting a rule and have no idea how to do it but know that it is achievable.
I get sent a spreadsheet daily and it consists of names and address of customers that i visit.
What I do is copy and paste the spreadsheet i recieve daily into a main spreadsheet with previous entries.
It looks a little like this:
AM MISS Jennie newton #07949087357 12 Mountwood
AM MRS Shaheen Zaman Khan #02036241594 121 Manor Road North
AM MISS Zakiyya Devaney #02083914847 29 Thrigby Road
I need it to recognise if i have been the before and highlight the row in a colour automatically when i copy and paste each days work in.