Hi
Have a look at some of Debra Dalgeish's stuff using formulas in
conditional formatting

http://www.contextures.com/xlCondFor...html#Duplicate

regards
Paul

jay dean wrote:
In range("A1:AZ4000").cells are data. This macro should check to ensure
that EACH figure in the above range appears ONLY ONCE.
If there are more than one of ANY value, then it should color the cells
containing the additional (redundant or repeated) values red.

Any help would be appreciated.
Thanks
Jay Dean

*** Sent via Developersdex http://www.developersdex.com ***