Now I'm probably pushing the envelope, but can this be added...
I've got a header at the top of each column of numbers. Once the
conditional formatting finds a cell to highlight... can the header cell
of that column also be highlighted? This keeps me from having to scan
over all the columns looking for the highlighted cells... I can just
scan across the header row, spot the highlighted header cell and then
scroll down to find the unique number.

Thanks again for your help.


--
dlvgolf
------------------------------------------------------------------------
dlvgolf's Profile: http://www.excelforum.com/member.php...fo&userid=6628
View this thread: http://www.excelforum.com/showthread...hreadid=383774