I'm trying to figure out a way to highlight the text color in cells that
are out of range. For example, I have column that needs data input
within a range of 1.5 to 3.0 If someone inputs a number outside that
range, I'd like to have the number that was input highlighted and
possibly a small electric shock sent to the keyboard (just kidding).
Is this something that I can do without VB? Can someone please point
me in the right direction?

Thanks for your help


Andrew


--
andrewb91
------------------------------------------------------------------------
andrewb91's Profile: http://www.excelforum.com/member.php...o&userid=27129
View this thread: http://www.excelforum.com/showthread...hreadid=466446