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

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

Thank you. Match worked perfectly.


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

You can use conditional formatting. Set up a list of your "good"
numbers. Select the first cell in your range to apply the formatting
to. Go to the Conditional Formatting and select the Formula is:
option. Enter this formula

=MATCH(A1,$J$1:$J$15,0)

This assumes your group of "good" numbers to match against is in J1:J15
and your values to change the fill color of are in A1:A15. Use the
format painter to copy down the rest of your range where you wish to
apply the format
(A2:A15).



HTH

Steve


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