Tag Archives: tutorial

How to use conditional formatting to shade every other row in Excel

The other day I was on MS Excel and I wanted to have every other row colored, since it was really difficult to read due to the content that I had.  I found a really good solution where all you would have to do is to

  1. Select the rows that you would like to color
  2. Go to Format -> Conditional Formatting
  3. In Condition 1 change it to select Formula Is instead
  4. enter the following formula =MOD(ROW(),2)=1
  5. Click on Format button
  6. When then new box opens up, click on the Patterns tab
  7. Pick the color that you would like, and then click OK.
  8. Now on the Conditional Formatting dialog box, click OK.

Then enjoy your colors on every other row 😛

Source How to use conditional formatting to shade every other row in Excel.

Installing Tor in Ubuntu Hardy

before i show you how to install tor in ubuntu hardy, i am going to explain a little bit what exactly tor is.

Tor is a software project that helps you defend against traffic analysis, a form of network surveillance that threatens personal freedom and privacy, confidential business activities and relationships, and state security. Tor protects you by bouncing your communications around a distributed network of relays run by volunteers all around the world: it prevents somebody watching your Internet connection from learning what sites you visit, and it prevents the sites you visit from learning your physical location. Tor works with many of your existing applications, including web browsers, instant messaging clients, remote login, and other applications based on the TCP protocol.

Retrieved from torproject.org

So if you want more information go and visit torproject.org and you will be able to answer all your questions.  so now lets go and install tor in ubuntu.

Steps:

  1. Open your “Terminal” and type “sudo apt-get install tor”
  2. after tor is installed now you will need to install privoxy.  for that you will need to go to this page and download you system architecture version (http://sourceforge.net/project/showfiles.php?group_id=11118&package_id=35042&release_id=627607).  in my case is privoxy_3.0.10-1_i386.deb.after having both programs install now is all about configuration of just one of them ;).
  3. now, on your “Terminal” make a copy of the configuration file from privoxy folder. in my case would be “sudo cp /etc/privoxy/config /etc/privoxy/config-backup”
  4. make a new file with “sudo nano /etc/privoxy/config”
  5. paste the following information:

    # Generally, this file goes in /etc/privoxy/config
    #
    # Tor listens as a SOCKS4a proxy here:
    forward-socks4a / 127.0.0.1:9050 .
    confdir /etc/privoxy
    logdir /var/log/privoxy
    actionsfile standard # Internal purpose, recommended
    actionsfile default # Main actions file
    actionsfile user # User customizations
    filterfile default.filter

    # Don’t log interesting things, only startup messages, warnings and errors
    #logfile logfile
    #jarfile jarfile
    #debug 0 # show each GET/POST/CONNECT request
    debug 4096 # Startup banner and warnings
    debug 8192 # Errors – *we highly recommended enabling this*

    user-manual /usr/share/doc/privoxy/user-manual
    listen-address 127.0.0.1:8118
    toggle 1
    enable-remote-toggle 0
    enable-edit-actions 0
    enable-remote-http-toggle 0
    buffer-limit 4096

    Retrieve from https://wiki.torproject.org/noreply/TheOnionRouter/PrivoxyConfig

  6. exit out from the program (nano NOT terminal) and save it.
  7. go to this site to install the tor plug in for firefox.  Tor Plug in.
  8. after firefox is restarted click on the “Tor Disabled” button in the bottom to enable it, and to check that it works properly go to check tor installation.

if it works, congrats.  if it doesn’t sorry.  go back and check this tutorial or go to tor website to get support.

Import from another blog

wordpress is so nice that it allows you to import stuff from another blog into wordpress. i currently imported all my data from my old blog from msn live spaces to wordpress. it is really easy to do and it was done through RSS.

this tutorial was done using firefox but i bet that you could use another web browser app.

Steps:

  1. go to you old blog OR the blog where you are going to be exporting the information
  2. click on the RSS button in order to load it
  3. once you have the RSS open, go to “File” > “Save Page As...
  4. save as “feeds.rss
  5. Now go to your wordpress blog
  6. go to “Manage” > “Import
  7. click on “RSS
  8. Browse” the file that you just saved as “feeds.rss
  9. then click “Upload file and import
  10. now your old blog should be in the wordpress database uploaded

Remove “click to activate and use this control”

This hack or tutorial it is for web admins that what to remove the “click to activate and use this control” that appears in IE7 or above.

Steps:

  1. Goto your last <object> and write this below
    <script type="text/javascript" src="NoActiveAndUseThisControl-IE7.js"></script>
  2. Now, open notepad and copy and paste this code into notepad.
    theObjects = document.getElementsByTagName("object");
    for (var i = 0; i < theObjects.length; i++) {
    theObjects[i].outerHTML = theObjects[i].outerHTML;
    }
  3. Save As this file and name it as “NoActiveAndUseThisControl-IE7.js
  4. Now upload them into your server and you should be good to go ;).

Export friend and blacklist from Mailwasher

This is a tutorial that it will illustrate how to export your friend and black list from Mailwasher 5.3 on Windows XP.

I been using Mailwasher for quite while now and it is a really good application to catch spam, but I was wondering how to come up with something that I could export my friend and black list from their application. Unfortunately you could only import *.csv files into their app and not export any data. Well, I bet that you are wondering how to export your list and post it on another email account of yours.

Steps:

  1. Open “Windows Explorer
    Make sure that “Show hidden files and folders” it is chose. Don’t know how to do this click here.
  2. Replace “your_user” for your Windows XP account user name
    Go to “C:\Documents and Settings\your_user\Application Data\MailWasherPro
  3. Copy “Blacklist.txt” to your Desktop or desire folder
  4. Open “Blacklist.txt” with your desire application. Add and remove all the email addresses that you want from it.
  5. Save As” Blasklist file and make sure that you change the extension to the extension that your email account is asking for you to import your email friend and/or blacklist. Usually they always use *.csv format.

Now you are done. That was easy wasn’t it. 😛