Highlight cells that contain non-integer values

[Routus]

Hi all.

I have a spreadsheet with a range of cells (J317414 - AN317720) that should only contain Integer values, but I'm pretty sure that a non-integer value has crept in there somewhere! Does anyone know if there is a formula I can apply to the range in order to find the problem, and maybe highlight the cell, please?

Thanks in anticipation

Paul

 

[JamesCanale]

MrExcelPlayground.xlsm
	L	M	N
15	5	5	4
16	1	4	6
17	1	6	5
18	2	7	5
19	3	5.001	4
20	4	43	4
21	5	35	4.3
22	6	6	46
23	4	7	4
24	3	7	4
25	3	5	3
Sheet46

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
L15:N25	Expression	=MOD(L15,1)>0	text	NO

 

[Routus]

MrExcelPlayground.xlsm
	L	M	N
15	5	5	4
16	1	4	6
17	1	6	5
18	2	7	5
19	3	5.001	4
20	4	43	4
21	5	35	4.3
22	6	6	46
23	4	7	4
24	3	7	4
25	3	5	3
Sheet46

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
L15:N25	Expression	=MOD(L15,1)>0	text	NO

Thanks James, I'll have a look at this