Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Range of data within a column
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
enter data on 1 sheet and make it enter on next avail row on 2nd s | Excel Discussion (Misc queries) | |||
Combining workbooks with some variable field names | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Vlookup of parts of a word in a range of Data | Excel Discussion (Misc queries) |