You want conditional formatting
Look up 'Highlight cells that meet specific conditions' in the Answer
wizard in help
--
HTH
Bob Phillips
"neilwebb" wrote in
message ...
hi there
i have data which is either in tolerance, or out of tolerance. i need
the data to be black in tolerance and red out of tolerance. in
tolerance is 140.50 to 145.00 any thing else is out of tolerance.
many thanks
neil
--
neilwebb
------------------------------------------------------------------------
neilwebb's Profile:
http://www.excelforum.com/member.php...o&userid=24450
View this thread: http://www.excelforum.com/showthread...hreadid=387938