Hi guys,
I'm kind of a newbie so please be gentle.
I have a column with email addresses and i would like, when add a new one in the bottom of the column to be informed (highlithed text) if i allready have it in my list.
I suppose is to be done with Conditional formating.
A1: [email protected]
A2: [email protected]
A3: [email protected]
A4: [email protected]
A5: [email protected]
etc.
Great thanks,
Spiep
Hi and welcome to the forum.
Yes you can do it with Conditional formatting.
Highlight your area(in the example, A1:A10) and Formula is: =COUNTIF($A$1:$A$10;$A1)>1
Change semi-colon, to gomma, if you have to do it.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Yep, it worked!
but now i'll go nasty! how can i do it with google docs?
Efharisto!
Parakalo-te rog(You are welcome!)
For your new requietment, i am not sure what exackly you asked for....
Would you like to explain it, more, or even better, to upload a sample workbook??
So... the same request but not for standard Excel, but for the Google Docs online version.
https://docs.google.com
Sorry. I have never used this! So i don't know!
yey, thanks anyway!Originally Posted by Fotis1991
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks