Monthly Archives: January 2012

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.

Move messages from one Lotus Notes archive to another archive

Just recently I found out how difficult is to search through out my split archives.  I found this recourse but, really doesn’t give me the information that I need in order for me to be able to merge my archive *.nsf files.  So, instead here I am documenting how you can merger multiple Lotus Notes archive files.

  1. make sure that your folder structure is the same across archives.  If is not, then create the folders in the archive where you will be moving the data to.
  2. backup your archives just in case something goes wrong
  3. create an archive replica where you would like to move the files to
  4. go to your workspace
  5. right click on the replica that you would like to move data from
  6. go to Applications -> properties
  7. Click on “Archive Settings…”
  8. Create a new setting.
  9. Click “Selection Criteria…” . In this case we are going to move any file that hasn’t been modify in the last 1 day.
  10. Check “Enable this criteria”
  11. Update the section “What Should Happen to the Selected Documents?” and choose the archive db where you will be moving this data to.
  12. Once you are done click “OK”, then “OK” again.
  13. At this point you should be back to the workspace.  Double click/open on the archive db that you would like to move data from.
  14. Go to File -> Application -> Archive…
  15. Then hit “Yes”
  16. Let it run in the background until all your emails has been moved.  Hit F9 to refresh window if you are not sure if all your emails have been moved.
  17. before saying viola … double check that everything has been move and then viola!!! enjoy having only one archive.

Let me know whether this documentation didn’t help you or not 🙂

Source Move messages from one Lotus Notes archive to another.

Stop Online Piracy Act (SOPA) – Help Mozilla stop Internet Censorship Legislation

In case that you were not aware.  A new law will be passed in the senate as early as January 24th.  What this would mean is that what we know of the Internet could change by controlling our freedom to express our selves and it could bring websites like Facebook to track what we post, etc.

here is a video if you would like more information

PROTECT IP / SOPA Breaks The Internet from Fight for the Future on Vimeo.

See how Google, Wikipedia, and Mozilla has join the act.

I am not an expert in this area so if you would like more info you could visit Mozilla in the source section.

Source Help Mozilla stop Internet Censorship Legislation.

What does each menu means in ClockworkMod Recovery On Android

i just recently rooted my phone just for the heck of it.  being a first timer i found a really difficult part on know what each menu meant.  the link below will give you some good documentation on what each thing means. hope it helps you folks as much as i has helped me 🙂 .

How to use the ClockworkMod Recovery on Android

Source What Is ClockworkMod Recovery And How To Use It On Android [Complete Guide].

Hotmail: Mobile – Instructions to get Hotmail on a mobile phone.

about time microsoft finally release some type of documentation in terms of having their products being able to sync with mail, contacts, and calendars in the mobile area.  now it will be a matter of centuries before they could catchup with google. 😛

Source Hotmail: Mobile – Instructions to get Hotmail on a mobile phone..

System Monitor Indicator For Unity Panel In Ubuntu 11.10 Oneiric Ocelot

If you install the new version of Ubuntu 11.10 Oneiric Ocelot you will notice that it comes with Unity installed in order to make a better OS experience.  That could be very well true, but I do like to see my system monitor and see how my PC is behaving.  Now, it can not be easily done with unity, but if you would like to do it, go to the link below and you will be able to find steps by using PPA in order to get your system monitor on unity.  Also, if you don’t like unity you could go back to gnome, but that is something different that is not being cover in this article. 🙂

Source http://www.linuxnov.com/system-monitor-indicator-for-unity-panel-in-ubuntu-11-04-natty-narwhal/