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?