software

I have a very small field of results but a large list of numbers that
are quot;goodquot; 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: www.excelforum.com/member.php...foamp;userid=4144
View this thread: www.excelforum.com/showthread...hreadid=530664
You can use conditional formatting. Set up a list of your quot;goodquot;
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 quot;goodquot; 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: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=530664try using the conditional formating and in the cell value... use quot;equalsquot; and
type in =if(countif(quot;your array of numbersquot;,quot;the cell field with the number
you're checkingquot;)gt;=1,true)

quot;langbaquot; wrote:

gt;
gt; I have a very small field of results but a large list of numbers that
gt; are quot;goodquot; numbers. They are not sequential. I'd like to have any one
gt; of these few numbers to highlight if they equal any of the many numbers
gt; from the large list. Conditional format does not allow me to select an
gt; array but I remember seeing somebody do something like this without a
gt; macro. I don't know much about macros.
gt;
gt;
gt; --
gt; langba
gt; ------------------------------------------------------------------------
gt; langba's Profile: www.excelforum.com/member.php...foamp;userid=4144
gt; View this thread: www.excelforum.com/showthread...hreadid=530664
gt;
gt;


Thank you. Match worked perfectly.--
langba
------------------------------------------------------------------------
langba's Profile: www.excelforum.com/member.php...foamp;userid=4144
View this thread: www.excelforum.com/showthread...hreadid=530664