Highlighting items in list

JD · Mar 12, 2004

I have a sheet with a list of customers in column A. I
would like to create a formula or conditional format that
will change the font to blue and background to yellow
when the customers name shows up 3 or more times on the
list. Can anyone help me with this?

JulieD · Mar 12, 2004

Hi JD

Check out Chip Pearson's excellent website at

http://www.cpearson.com/excel/duplicat.htm

particularly the topic on Highlighting Duplicate Entries

i changed the formula to
=IF(COUNTIF(range1,A1)>3,TRUE,FALSE)
and it did what you wanted

Cheers
JulieD