Or , conditional formating

[jtodd]

HI , I have a data set that i need to highlight (will be upto 10) certain numbers in the same column and thought this would be easy but!!!!!!!
I have the folowing formula in my conditonal formating (there are only 2 numbers in example i will need up to 10)

result - (small sample)

as you can see it seems to highlight random numbers , i have done this with text successfully but cannot get this to work!!!!!!!!!
or is there a better approach!
There are 15 colulmns and i will need to highlight the whole row.

 

[arthurbr]

Is H2 the first cell in your reference range ?
Change H2 to $H2 in your CF

 

[etaf]

create a list somewhere on the sheet with all the numbers that you want
Then you can us a countif()
as shown in the example

COUNTIF( range in your list, first cell in data)>0

Book2
	A	B	C	D	E	F	G	H	I	J	K	L
1											LIST
2	1	5	2	8							12
3	2	6	3	9							4
4	3	7	4	10							2
5	4	8	5	11							16
6	5	9	6	12
7	6	10	7	13
8	7	11	8	14
9	8	12	9	15
10	9	13	10	16
11	10	14	11	17
12	11	15	12	18
13	12	16	13	19
14	13	17	14	20
15	14	18	15	21
16	15	19	16	22
17	16	20	17	23
18	17	21	18	24
19	18	22	19	25
20
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A:D	Expression	=COUNTIF($K$2:$K$5,A1)>0	text	NO