S

#### Steve B

group of numbers does not equal (<>) a certain cell value. However, it

appears that even when the condition is "False" the cells are turning Red.

When I check the total from the cells being compared they the same as the

comparitor cell and thus should not turn red.

The cells feeding the range being evaluated are comprised of formulas that

derive numbers. Because they are formulas the decimal calculation are

carried out beyond 5 decimal places. If I type in the result to less than 5

decimal places the conditional formula works correctly.

Does anyone know how to truncate the formulas at 4 or less decimal places?

E.g. simply setting the cell to that number does not truncate it vs. simply

showing that level in the spreadsheet.

Or, can anyone explain how to get around the problem without deleting the

formulas?

The conditional formula looks something like the following:

formula Is: =(SUM($C$8:$F$8)+$AU$8)<>$H$3 with format to turn cell Red if

statement is true.