Conditional Format Based on Decimal Value

[Steve 1962]

Hi All

Just wondering if there is a conditional formating rule that only formats the cell if the first decimal is .5.

In the example, this would only format cell A1.

Thanks

Book1
	A
1	7.5
2	7.0
Sheet1

 

[Cubist]

Try:

=MOD(A1,1)=0.5

 

[Steve 1962]

Thanks Cubist. Works fine.

Have a good week.