Conditional Formatting & Rounding

[Lakem]

Hi,

I am after a way to highlight a cell if the number is greater than .5 of a number, more that half numbers.
I know this can be done with the round function however I want to highlight with a colour using conditional formatting

Eg 5.6, 10.9 etc

 

[SanjayGMusafir]

Check this and revert -

Book1
	D
3	5.5
4	5.6
5	5.51
6	5.4
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D3:D6	Expression	=D3-TRUNC(D3)>0.5	text	NO

 

[Fluff]

Hi & welcome to MrExcel.

Another option

Fluff.xlsm
	A
1
2	11.49
3	1.3
4	17.6
5	2.5
6	3.6
Sheet6

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:A6	Expression	=MOD(A2,1)>0.5	text	NO