Using Excel’s conditional formatting to colorize the weekends

In this period of the year most of us are starting to make plans for next year, Excel is an incedibly powerfull tool that can help you visualize your plans. Using Excel’s conditional formatting you can colorize the weekends and make them standout more than the other days of the week or vice versa. This article is an How to colorize the weekends in Excel using conditional formatting.

To colorize the weekends in Excel using conditional formatting, based upon the date in column B, you can use the following formula:



To create a rule using conditional formatting:

  • Select the cells that you want to apply the conditional formatting to.
  • Click “Conditional Formatting”.
  • Choose “New Rule”.
  • In the “New Formatting Rule” dialog box, choose “Use a formula”.
  • Under “Format values”, type the formula: =IF(OR(WEEKDAY($B2)=1;WEEKDAY($B2)=7);1;0)
  • The formula uses the dates in column B (You can select your own column with dates, by replacing the $B2 part in the formula with the column letter of your choice).
  • Click “Format”.
  • In the “Color” box, select your favourite color.
  • Click “OK” until all dialog boxes are closed.


Suggestions for improving this article are welcome, please let me know and drop me a line.

Give your Raspberry Pi a fixed IP address

Having a fixed (or static) IP address on your Raspberry Pi, comes in handy if you want to access your Raspberry Pi from the internet (for a how to about port forwarding, read this article). As you might want to use ownCloud for instance.

You can give your Raspberry Pi a fixed IP address by editting the network interfaces file.

But first, we are making a backup of the old configuration!

sudo cp /etc/network/interfaces /etc/network/interfaces.bak


Next thing is, editing the network interfaces file:

sudo nano /etc/network/interfaces


Although the IP address you want to use might be different, make your /etc/network/interfaces look like this:

auto eth0                                     # The loopback interface

iface eth0 inet static              # Tells your Raspberry Pi to use a static IP address

address            # Defines the static ip address
gateway              # Defines the gateway to use (choose the IP address of your modem)
netmask     # Defines the subnet mask

network             # Defines the network family
broadcast    # Defines the network family


You can save the adjustments you made to your /etc/network/interfaces file by pressing ctrl o

Press ctrl x to exit


After saving your new settings, you need to activate them by restarting your network components:

sudo /etc/init.d/networking restart


Suggestions for improving this article are welcome, please let me know and drop me a line .

Getting Broadcom STA to work on Ubuntu Studio 13.04 or Xubuntu

As I upgraded Ubuntu Studio 12.10 to Ubuntu Studio 13.04 on my Mac Book 5.1 my wireless stopped working… After surfing the internet for a couple of days I’ve found the following solution to enable the Broadcom STA on my Mac Book 5.1.

Check whether Ubuntu sees your Broadcom STA device by running the lspci command from a terminal:

lspci | grep Network


After using the the lspci command you should get something like this:

03:00.0 Network controller: Broadcom Corporation BCM4322 802.11a/b/g/n Wireless LAN Controller (rev 01)


Next up is, installing the drivers. To install the drivers run the following command using the terminal:

sudo apt-get install firmware-b43-installer


The broadcom-sta-common package, blacklists the b43 driver.

To fix this you need to edit the file: /etc/modprobe.d/broadcom-sta-dkms.conf


You can do that by using the following command in the terminal:

sudo nano /etc/modprobe.d/broadcom-sta-dkms.conf


Delete or comment out with a “#” the line “blacklist b43”, my file looks like this:

# wl module from Broadcom conflicts with the following modules:
# blacklist b43
blacklist b43legacy
blacklist b44
blacklist bcma
blacklist brcm80211
blacklist brcmsmac
blacklist ssb


Then to force the module to load during boot by using the following command in the terminal:

sudo nano /etc/modules


Then add a line with “b43”, my /etc/modules file looks like this:

# /etc/modules: kernel modules to load at boot time.
# This file contains the names of kernel modules that should be loaded
# at boot time, one per line. Lines beginning with “#” are ignored.


You don’t need to reboot your computer as you can load the module manually by entering the following command in the terminal:

sudo modprobe b43


Suggestions for improving this article are welcome, please let me know and drop me a line.

Remove X or create a headless server on a Raspberry Pi

As I use my Raspberry Pi as a headless server, I thought it would be a good idea to clean up unnecessary files. After studying some material from others and several attempts later, I distilled the following steps…

Login to your Raspberry Pi, so open a terminal and use SSH…

Step – 1: To get rid of orphaned files later, we are going to install a program called deborphan first:

sudo apt-get install deborphan


Step – 2: Next we are going to remove all desktops from your Raspbian (if you don’t want to remove samba, remove it from the following command!):

sudo apt-get remove –auto-remove –purge libx11-.* lxde-.* raspberrypi-artwork xkb-data omxplayer penguinspuzzle sgml-base xml-core cifs-.* samba-.* fonts-.* desktop-* gnome-.*


Step – 3: Now we are going to remove all orphaned files:

sudo apt-get remove –purge $(deborphan)


Step – 4: After that it is time to remove the unnecessary packages that are not orphaned:

sudo apt-get autoremove


Step – 5: You can even free up more space by removing the locales:

sudo apt-get install locale:purge:
sudo localepurge


Step – 6: Clean up some more:

sudo apt-get clean


Step – 7: You might need to reinstall the following packages for squeezelite:

sudo apt-get install -y libflac-dev libfaad2 libmad0


Step – 8: Reboot If you want, else stop start the service:

sudo shutdown -r now


By doing a “before and after“, you can see the difference:

df -h /dev/root


Suggestions for improving this article are welcome, please let me know and drop me a line .

How to EQ vocals

Of course there is no exhaustive and conclusive answer to “how to EQ vocals“, but there are some guidelines you can follow and that offer you reasonable results even if you’re not into audio.

You can use the following 4 steps within your audio package of choice.

Step 1 – Remove low frequency rumble
Set your “High Pass Filter” somewhere between 80 and 120 Hz

Step 2 – Add more freshness to audio track
Top shelf, boosting high from 8 kHz with 1 to 6 db (if you want to do it subtle: 12 – 16 kHz)

Step 3 – Reduce offending frequencies
Sweep your vocal track by using a small bell curve, to find offending frequencies round 800 – 1 kHz and reduce them by -3 db

Step 4 – Make vocals more outstanding
Boost the vocal presence in your mix, by boosting the range between 2 – 5 kHz with 1 to 4 db



  • With everything you do while EQ ing your audio, listen carefully to the results!
  • Never work on your original files, always use a copy!


Suggestions for improving this article are welcome, please let me know and drop me a line .