On Mon, 5 May 2008 08:44:03 -0700, jazzii
wrote:

Hi, thanks for the info. I will need the forth condition as well, i.e. if
-10.1, show as 10 in Red.

However, I do not know VBA. If there is another other method, please share
thanks!!

You could use a formula to round numbers appropriately, and then format to RED
or not depending on if the result is ABS(10).

Do you have formulas in the cells?

If not, you will have to separate your data entry from your display.
--ron