Finding numbers in rows and highlighting them

J

Johncobb45

Hi everybody :)
I need help.
This is a lotto system.
I have a spreadsheet with 508 rows and 45 columns.
In each row there are 45 numbers mixed (1 to 45).
I need a script or some other way to find where particular (drawn)
numbers are in each of the 508 rows.
If my explanation is not clear please ask for farther clarification.
Thank you in advance for your help.
Joh
 
D

Domenic

Using conditional formatting...

1) Select your range

2) Format > Conditional Formatting > Formula Is

3) Enter the following formula:
=MATCH(A1,$AP$1:$AP$6,0)

4) Choose your formatting

5) Click OK

...where A1 is the first cell in your range and AP1:AP6 contains you
six numbers.

Hope this helps!
 
Top