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 |
#2
|
|||
|
|||
Yes.
Use Conditional formatting. Pull-down Format Conditional Format and add your conditions. -- Gary''s Student "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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
That works, perfectly. Thanks for the info -- andrewb91 ------------------------------------------------------------------------ andrewb91's Profile: http://www.excelforum.com/member.php...o&userid=27129 View this thread: http://www.excelforum.com/showthread...hreadid=466446 |
#5
|
|||
|
|||
On Fri, 9 Sep 2005 19:28:29 -0500, 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 One other thing you could do is to use Data Validation to restrict the entry range to that which is valid. If the user inputs a number outside that range, Data Validation will disallow that and pop up a warning message. (Perhaps you could key you electric keyboard shocker to that message). Data/Validation Allow: Decimal Data: Between Minimum: 1.5 Maximum: 3.0 And you can customize the error message; and also have a balloon popup with info when the cell is selected. --ron |
Reply |
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) |