Hi,

There is another way to achieve the desired result.

Press Ctrl+1
Now in custom number format, enter the following

[Red][<1.5]0;[Red][3]0;General

Click OK

Now if you enter moire tna 3 or less than 1.5, the cell becomes red

Regards,

"andrewb91" wrote:


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