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

--
---
HTH

Bob


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



"Scott R" wrote in message
...
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