Select the column, then use conditional formating, under format.

Change the dorp down to "formula is" then X change format to what you
desire

Click add. Do the same for <x.


--
Paul987
------------------------------------------------------------------------
Paul987's Profile: http://www.excelforum.com/member.php...o&userid=24850
View this thread: http://www.excelforum.com/showthread...hreadid=387546