Conditional formatting

[seanbtrini]

I have a conditional format set up for some of my cells to be
different colors based on the value, (less than, more than or equal
to). It is set up using a calculation, the calculation has decimal
places that are messing up the format. Just formatting cells and
taking out the decimal place is not working because it is still
recognized. How can I get the calculation to bring back only whole
numbers?

 

[Guest]

It would be helpful to have seen you calculations but in the absence of that
generally to get a formual to produce a whole number (integer) use INT:-

=22/7 > 3.142857143

=int(22/7) >3

Mike