CONDITIONAL FORMATTING: Cells with 32nd fractions

[itr674]

Is there a shorter way to write the below conditional formatting formula for cells that contain 32nds?

=OR (E37=3/32, E37=5/32, E37=7/32, E37=9/32, E37=11/32, E37=13/32, E37=15/32)

I tried MOD(cell reference, 1/32)=0 but it is highlighting cells that are 32nds.

 

[6StringJazzer]

This is as simple as I could get it:

=AND(A1>1/32,A1<=15/32,ISODD(INT(32*A1)),MOD(A1,1/32)=0)

$scratch.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1	1/32	1/16	3/32	1/8	5/32	3/16	7/32	1/4	9/32	5/16	11/32	3/8	13/32	7/16	15/32	1/2	17/32	9/16	19/32
Sheet19

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1:S1	Expression	=AND(A1>1/32,A1<=15/32,ISODD(INT(32*A1)),MOD(A1,1/32)=0)	text	NO

 

[itr674]

This is as simple as I could get it:

=AND(A1>1/32,A1<=15/32,ISODD(INT(32*A1)),MOD(A1,1/32)=0)

65StringJazzer, wow that was quick and it worked but have one issue.

I have two cells, one calculates the decimal version of the 32nd, and another cell shows the fraction version, and I just want to highlight the fraction version, and those cells are formatted as ##/##

 

[itr674]

Correction to last line of original post:

I tried MOD(cell reference, 1/32)=0 but it is highlighting cells that are NOT 32nds.

 

[6StringJazzer]

I have two cells, one calculates the decimal version of the 32nd, and another cell shows the fraction version, and I just want to highlight the fraction version, and those cells are formatted as ##/##

There is no built-in function that can tell you whether the cell is formatted as a fraction, so conditional formatting can't distinguish between these two cells. I thought the CELL function would do it but both cells return "G" for "format".

 

[itr674]

65StringJazzer, copy, and thank for the help.