Tag: Google

Conditional Formatting / Bedingte Formatierung in Google Docs

Kurzes Snippet, weil ich mich gerade so dämlich angestellt habe!

Ich wollte eine ganze Zeile abhängig vom Inhalt einer Zelle formatieren.

Dazu Format Cells if “Custom Formula” und dann:
=EQ($E2,”Done”)=TRUE

Wichtig dabei $ vor die Spalte, weil er sonst für jede Zelle in der Zeile die Abfrage Zelle nach rechts fortschreibt.
Ohne =TRUE am Ende geht es nicht, wenn ich mich recht erinnere impliziert das Excel automatisch, wenn keine Parameter angegeben sind.

Enabling Google Talk on Google Apps for Domain

Today i tried to connect to my gtalk hosted on google apps for domain but the connection was refused. Which, by the way, seems logical as i do not host any jabber/xmpp services on my domain neither redirect to gtalk.
A quick google search got me the Google help page How can my users chat outside the Google network with the following table for the DNS entries; replace gmail.com with yourdomain.tld
_xmpp-server._tcp.gmail.com. IN SRV 5 0 5269 xmpp-server.l.google.com.
_xmpp-server._tcp.gmail.com. IN SRV 20 0 5269 xmpp-server1.l.google.com.
_xmpp-server._tcp.gmail.com. IN SRV 20 0 5269 xmpp-server2.l.google.com.
_xmpp-server._tcp.gmail.com. IN SRV 20 0 5269 xmpp-server3.l.google.com.
_xmpp-server._tcp.gmail.com. IN SRV 20 0 5269 xmpp-server4.l.google.com.
_jabber._tcp.gmail.com. IN SRV 5 0 5269 xmpp-server.l.google.com.
_jabber._tcp.gmail.com. IN SRV 20 0 5269 xmpp-server1.l.google.com.
_jabber._tcp.gmail.com. IN SRV 20 0 5269 xmpp-server2.l.google.com.
_jabber._tcp.gmail.com. IN SRV 20 0 5269 xmpp-server3.l.google.com.
_jabber._tcp.gmail.com. IN SRV 20 0 5269 xmpp-server4.l.google.com.
I logged in my Plesk 9.x.x. control panel and tried to add the SRV record. The first attempt was a failure, because i tried to paste the whole “_xmpp-server._tcp.gmail.com.” thing into the “Enter domain name” field. You will see that Plesk builds the correct entry itself when you fill in the fields.
Correct Input is:
Service name: 'xmpp-server' // 'jabber'
Protocol: 'TCP'
Enter domain name: ''
Priority: as given above
relative priority '0'
Target Host: as given above
Target Port: 5269

Client configuration for Pidgin or other IM can be found at http://www.google.com/support/a/bin/answer.py?hl=en&answer=49147