How to set up Google Docs for IP address checks?

[CCJay]

Hi,

Seen a few posts on here about Excel and IP address' and making notes of them.

I would like to put this into google docs/sheets and it is instant save and instant shared across accounts, so none of the save excel and share between the accounts i need. Plus if using another laptop (if needs must etc)

Originally Posted by JamesNorth101

This is a very easy way to make sure that you never use the same IP address twice.

At the top of excel select the column A.


Select the conditional formatting button at the top of the page under the home tab

Select highlight cell rules, then duplicate values.

Make sure the left drop down cell says duplicate, and then select what ever works best for you on the right, I choose light filled red with dark red text personally. Then click ok.

After that is done, click column A again, conditional formatting, select highlight cell rules, then duplicate values again. This time change the left hand drop down value to unique, then the right hand drop down menu to again what ever suits you. I choose green filled with dark green text.

If the cell lights up red, you need to get a new IP, if it lights up green your good to go

Hope this helps

[rsot]

Network shared drive use?

[GreenBean]

What are you trying to say?

[JamesNorth101]

I always find it easiest to just use a USB stick.

[spideyman]

Originally Posted by JamesNorth101

I always find it easiest to just use a USB stick.

That's a great idea thanks ☺
Also would the paid version of IPBurger work on the usb stick too to save ip addreses

[rsot]

Originally Posted by spideyman

That's a great idea thanks ☺
Also would the paid version of IPBurger work on the usb stick too to save ip addreses

To record IP address likely so - but manual entry can be done into the excel form