In the absence of details about your situation, what is wrong with basing the
conditional format on a formula instead of a cell value? Then you could
round the cell value to determine the correct formatting.

Jerry

" wrote:

I have created a table to track contact milestones, I turned off the
display of decimals to avoid long numbers. Because of the accuracy of
the calculations I couldn't use "calculate as displayed", so now
because the decimals are present my formatting for less than, equal to
or greater than, doesn't work. Is there any other way to get this to
work without messing up my calculations.

Sean