Auto fill color by data reference?

[Sfinally]

Is there a way to look through an entire spreadsheet of data (in this case, hundreds of email addresses, one per cell) and highlight every instance of a given email by auto filling the cell a particular color? Any help is appreciated. Thanks.

 

[VoG]

Try Conditional Formatting http://www.contextures.com/xlCondFormat01.html