conditional formatting

[2Stupid2ownAputer]

Hello,
ID = 123 .01 (primary key)
conditional formatting change field colour
[id]-Int([id])=0.01

ID _ INT(ID)
123.01 -123 = 0.01
any ideas why this doesn`t work?
I tried format as well to no avail
regards

 

[Marshall Barton]

ID = 123 .01 (primary key)
conditional formatting change field colour
[id]-Int([id])=0.01

ID _ INT(ID)
123.01 -123 = 0.01
any ideas why this doesn`t work?

It's a floating point numbers thing. Try this

Int(ID * 100) - Int(ID) * 100 = 1

 

[2Stupid2ownAputer]

Thanks for that marsh
I knew It had to be something with the numbers but couldn't`t figure out
what to do about
Best regards