formula to show the message that number already entered

[Eliane]

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.

 

[carlo]

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