Go to Format-Conditional Formatting
Set your criteria and click the Format button to set your colors,
borders etc.
--
mphell0
------------------------------------------------------------------------
mphell0's Profile:
http://www.excelforum.com/member.php...o&userid=30153
View this thread:
http://www.excelforum.com/showthread...hreadid=519504