Lookup function (i think)

[Scott R]

Hi Guys, I think this is pretty basic but im not very good with lookups, ive
had a look thru prev posts but cant find this (prob because its so basic)..
I am entering data in many rows and putting $ amounts in column F. I need to
know when entering $ in Column F if that amount has been entered in that
column anywhere above. Maybe it could highlight red or something??
any help would be fantastic.. Thanks

 

[Bob Phillips]

See http://www.contextures.com/xlCondFormat01.html

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Gord Dibben]

Do you want to prevent a duplicate or just flag the duplicate?

See Chip Pearson's site on Duplicates.

http://www.cpearson.com/excel/Duplicates.aspx for flagging

http://www.cpearson.com/excel/NoDupEntry.aspx for preventing


Gord Dibben MS Excel MVP

 

[RagDyer]

OR ... you could go the other way, and *prevent* the duplicate entry in the
first place:

http://www.cpearson.com/excel/NoDupEntry.aspx

 

[Scott R]

I needed it to flag and those websites worked. Thanks Guys!