On Jul 2, 10:24 am, Jerry W. Lewis wrote:
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- Hide quoted text -

- Show quoted text -

Lets say I have a milestone number calculated for someone to meet, the
number is 9.012, I am displaying it as 9 on the sheet. I have a
conditional format of "if cell A1 is less than cell A2 (9.012) then
RED"; then the second format is "if A1 is equal to or greater than A2
then GREEN". Well if my cell A1 is 9 it will stay red because it is
less than A2, 9.012. I haven't used a formula because I don't know
how. I am in the learning mode.

Sean