| CCJay | 09-16-2014 03:16 PM |
How to set up Google Docs for IP address checks?
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) Quote:
Originally Posted by JamesNorth101
(Post 447887)
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
:typing:
| | 
