Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula to show the message that number already entered
i have do one file . at row H2 till H265 is for key in the IP address number.
Is it have the formula to prompt up the message if i key in double same ip address . if not same, then no need to show. Can someone help me. Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula to show the message that number already entered
Hy Eliane
you could use this formula in your conditional formatting: =COUNTIF($H$2:$H$265,H2)1 and then set the pattern to red, or something. As soon as you enter an IP Number twice, both fields become red. To enter the formula go to Cell H2, then: Formatting -- Conditional... change "Value is" to "Formula is" and enter the formula above. Click OK Now you can copy this to the right or, if you already have something entered, you can use the Format Painter (the Icon with the Brush) hth Carlo On Nov 21, 1:41 pm, Eliane wrote: i have do one file . at row H2 till H265 is for key in the IP address number. Is it have the formula to prompt up the message if i key in double same ip address . if not same, then no need to show. Can someone help me. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to tell if cell contains a FORMULA or user-entered number? | Excel Worksheet Functions | |||
How to give an error message if a cell value entered is larger than permitted | Excel Discussion (Misc queries) | |||
Show last number entered | Excel Discussion (Misc queries) | |||
Formula does not show as I entered it. | Excel Worksheet Functions | |||
numbers being entered show in formula bar but not in cell? | Excel Discussion (Misc queries) |