Conditional formatting

  • Thread starter Thread starter Jack
  • Start date Start date
J

Jack

Can someone plese help me with this little problem, it is
driving me mad at the moment.

I am trying to set a contitional cell format that will
highlight any cells that do not contain whole numbers
(integers).

i.e shade a cell that reads 1.25 and not shad a cell that
reads 125

I would greatly appreciate any assistance that anyone can
give me on this.
 
Hi
one way:
- select the cell
- enter the following formula for the conditional format dialog
=MOD(A1,1)<>0

or
=INT(A1)<>A1
 
Use this for your condition (assuming the active cell is A1):


Formula Is =INT(A1)<>A1
 
You could use:

=MOD(C10,1)<>0

this shows the remainder after dividibg the value by 1 -
if it isn't 0 then the conditional formatting kicks in.
paint the formatting to all relevant cells
 
Thanks Frank, it works a treat you have saved me from
pulling out what little hair I have left. Thanks again

Jack
 
Back
Top