Forum

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:

Originally Posted by JamesNorth101 (Post 520233)

Have a look at LibreOffice Calc

Originally Posted by MM78 (Post 448495)

Also, if you want to check your IP quickly here is a good way:

1. Enter your IP address associated with your Account

2. Click on "Find & Select" at the top right hand corner of Excel

3. Either Copy/Paste, or enter manually your IP in the search field

4. Click on "Find All"

This will find all the cells with the same IP, here's a little example.



http://i41.tinypic.com/33l0a48.jpg

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:

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:

Originally Posted by JamesNorth101 (Post 525726)

Uploaded as a zip file.

Originally Posted by Sandy D (Post 527863)

Awesome James!

How did the antiques you found do?