Easy Conditional formatting based on values of another column in Google Sheets

Before i’ve known the following tip, i used to format my cells in a google sheet based on the current day with indirection functions and such stuff. To check if the column A of the current row contains a date later than today, i used the following expression:


After a recent discussion with a colleague it could be made WAY easier. To conditionally format, e.g. the range of D6:N36 based on the date of the column A in the current row simply use instead:

=$A6 > TODAY()

and your’e done!

Sometimes life is way more simple than you think 🙂

Posted in Uncategorized | Leave a comment

Setting personalized ShortKeys in Xfce4 Terminal in LinuxLite (tested with 3.2)

Afaik, in newer versions of XFCE it’s possible to enable Menu Accelerators like in GTK+. LinuxLite 3.2 hasn’t this option enabled by default. For me i wanted that XFCE4 Terminal behaves like the gnome terminal, so i can move tabs using Shift+Ctrl+{PgUp|PgDown}.

The first step doing this is enabling the editable menu accelerators in the Settings:

Menu -> Settings -> SettingsManager -> Appearance -> Settings:
Activate “[] Enable editable accelerators”

see also: http://docs.xfce.org/xfce/xfce4-settings/appearance#menu_and_buttons

Afterwards simply open a menu item and press the desired Keyboard Combination to be used as ShortKey. To remove it, use Backspace. I don’t know if you can undo this.

Posted in Uncategorized | Leave a comment

Changing Line Styles of multiple lines in Enterprise Architect at once

  1. Open the relationship view: CTRL+SHIFT+2
  2. Select all elements on your diagram using the mouse and dragging a selection box around them (Ctrl + A does not work in this tip). Easiest way is to zoom out until the whole diagram is visible.
  3. This displays the Relationships dialog where you should see all the relationships for your diagram.
  4. Select one or more relationships in this dialog. Here you can use CTRL+A as you like
  5. Right-click and select Appearance… to change the width / colour of all selected relationships.
  6. Right-click and select Line Style to change the line style of all selected relationships.

Tested using Enterprise Architect 13

The original tip comes from: http://dthomas-software.co.uk/sparx-enterprise-architect-tip-of-the-month/


Posted in Uncategorized | Leave a comment

Keeping active edges with synergy

Consider you have two screens right beside each other:

 Curly        Moe
-----------   |XXXXXXXXXXXXXX|
|         |   |              |
|         |   |              |
|         |   |              |
-----------   ----------------

X – marks a region where you want to have a non-switching region, e.g. if you have active edges or different monitor heights.

For this case, synergy supports ranges in the links section. The ranges are given as percentages. For the case above, to exclude a small portion of the screen Moe, use the following setup:

section: links
        # the full right edge of Curly is mapped to 5% - 100% of 
        # the left edge of Moe
        right        = Moe(5,100)
        # same config but for the other side
        left(5,100)  = Curly

Using this feature you can realize partial overlaps on both sides as well. For detailed information look at the full synergy config documentation: Synergy Text_Config



Posted in Uncategorized | Leave a comment

Installing chrome as non root user

If you want to install google chrome as a non root user in debian (e.g. jessie) you have to simply:

1. Unpack the .deb manually

dpkg -x google-chrome-stable_current_amd64.deb /local/mysoft/chrome

2. Start chrome with –no-sandbox option

/local/mysoft/chrome/opt/google/chrome/chrome --no-sandbox
Posted in Uncategorized | Leave a comment

Redirecting the output of scp to a log file

Logging the output of scp (and similar commands) doesn’t work the straightforward way of a simple redirection because scp uses direct terminal codes and if it detects a redirection, it doesn’t output anything.

Fortunately there is a command called script which is able to simulate a terminal so the output could be recorded.

To trace the output of

scp $REMOTE_SERVER:~/test/test.file /dev/null

Wrap a script command around

# fetch the file, but don't store it locally
script -q -c "scp $REMOTE_SERVER:~/test/test.file /dev/null" 2>&1 | tee scpLog
# replace carriage return with newline
sed -i -e 's/\r/\n/g' scpLog

And your’e done

Posted in Uncategorized | Leave a comment

Find out which bad guy has fiddled on your workstation

Lastly i sat in a meeting and suddenly my vnc session to my workstation was killed. First, i thought we had some network problems, but i encountered my workstation was rebooted!

But how to figure out, who this was?

Luckily there’s a nice command called: last.

# Show last logged in users

This command basically uses the file /var/log/wtmp as it’s source. After a reboot this file seems to be rewritten, unfortunately.

# This file only goes back to the last reboot, so we need 
# to look around to find pevious version
ls /var/log/wtmp*

# => Output (filenames depend on your machine configuration, 
# i have a RHEL 7 box)

# the file itself is not human readable but could be used 
# as input for last
last -f /var/log/wtmp-20160114

Now could clearly see, who was the bad guy …

Posted in Uncategorized | Leave a comment