different colours for different data

Tech-Archive recommends: Fix windows errors by optimizing your registry


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?action=getinfo&userid=24450
View this thread: http://www.excelforum.com/showthread.php?threadid=387938

.

Quantcast