Conditional formatting & decimal part of a number in cell

[Mac]

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,
....)?

 

[Mac]

Uh oh, this does not seem to work; my numbers are either x.5 or x.0; I need
my x.0's get formatted and all x.5's left as they are. Might the decimal
format be the problem for MOD function?

 

[Mac]

David, the conditons you mentioned were all positive but th eproblem was -
for some reason, after having entered my condition formula and reopening the
Conditional Formatting dialog, the formula was surrounded by commas; deleted
those, saved, now it works great. Thanky you!!