I've included some screenshots. Let me know if I've interpreted what you
want incorrectly

again take special note of the active cell

the formula countif works as follows
=countif(range,criteria)
in a conditional format because the criteria does not have a $ anywhere
it will look in every cell in the range, so:
=if(countif(A$1:A$999,A1)2
will look in the range $A$1:$A$999 and count how many occurences of
each cell there is in that range. It says A1 because that's the active
cell. It repeats the procedure for every cell within the range


+-------------------------------------------------------------------+
|Filename: Conditional Format - Result.jpg |
|Download: http://www.excelforum.com/attachment.php?postid=5067 |
+-------------------------------------------------------------------+

--
MDubbelboer
------------------------------------------------------------------------
MDubbelboer's Profile: http://www.excelforum.com/member.php...o&userid=36330
View this thread: http://www.excelforum.com/showthread...hreadid=563460