=MOD(A1,1)=0

Or =MOD(ROUND(A1,1),1)=0 if you want to treat 4.02 as 4.0 in this respect.
--
David Biddulph

"Mac" wrote in message
...
Hello all,

in a conditional formatting scenario, which function do I use to decide if
the decimal part of the number in a cell is zero (i.e. x.0 and not x.1,
x.2,
...)?