If you use Formula Is vs. Cell Value Is and create your equation there
and set the conditions.

I have used this function comparing a value in a cell to the averave of
three other cells and changing the text to red if the cell value was
greater than the average.

Hope this helps.


--
TimR
------------------------------------------------------------------------
TimR's Profile: http://www.excelforum.com/member.php...o&userid=27843
View this thread: http://www.excelforum.com/showthread...hreadid=473502