(Normal.jpg) is what my normal data sheet will look like. I am conditionally formatting the values to be black when they are in between the upper and lower tolerances listed.

The problem arises when I try to conditionally format a value in degree(s). I calculate the actual degree from nominal degree, so I will occasionally have a negative degree (and my lower tolerance is a negative degree). It appears Excel thinks negative 1 degree is larger than zero degree. Excel puts the -1:30:00 above the 1:30:00 when I sort largest to smallest. (abnormal.jpg)

Any advice would be appreciated; and please go easy on me, its my first time!!

Attached Images

	normal.jpg (175.9 KB, 13 views)
	abnormal.jpg (200.1 KB, 14 views)