try using the conditional formating and in the cell value... use "equals" and
type in =if(countif("your array of numbers","the cell field with the number
you're checking")=1,true)

"langba" wrote:


I have a very small field of results but a large list of numbers that
are "good" numbers. They are not sequential. I'd like to have any one
of these few numbers to highlight if they equal any of the many numbers
from the large list. Conditional format does not allow me to select an
array but I remember seeing somebody do something like this without a
macro. I don't know much about macros.


--
langba
------------------------------------------------------------------------
langba's Profile: http://www.excelforum.com/member.php...fo&userid=4144
View this thread: http://www.excelforum.com/showthread...hreadid=530664