If you're like me and love the power of spreadsheets but don't miss Excel one bit, this new feature has been a welcome addition. Truth to be told, it should have been added years ago. But it's here now so let's see what we can use it for.
What conditional formatting is
With conditional formatting, a cell's appearance can reflect its contents. In the past, Google spreadsheets could be used to format cells based on whether a cell's value was higher or lower than what was specified, equal, empty et c. With formulas, this feature becomes considerably more powerful.
In-application window switching is extremely time-saving and convenient. Problem is the default mapping doesn't work with Swedish keyboard. I choose to use English on my Mac, and maybe that's why the region setting doesn't really get it entirely right. Well, either way it's quite painless to fix. Open "System Preferences..." click on "Keyboard" and the "Keyboard Shortcuts" tab. Then make sure the setting is as above. You need to double-click the shortcut (right column) and press the key combination you want.