Love I.T., Live I.T., Embrace I.T.

If you frequently run multiple programs simultaneously, your desktop can get extremely cluttered. This can get annoying if you’re working on one program and want to minimize all the other windows — in previous versions of Windows you had to minimize them individually.

With Windows 7’s “shake” feature, though, you can minimize every window except the one in which you’re currently working — in a single step. Click and hold the title bar of the window you want to keep on the desktop; while still holding the title bar, shake it quickly back and forth until all of the other windows minimize to the taskbar. Then let go. To make them return, shake the title bar again.

You can accomplish the same thing by pressing the Window key-Home key combination — although doing that is not nearly as much fun.

Conditional formatting is a Microsoft Excel feature that sets a cell’s format according to conditions that you specify. Conditional formatting allows you to present numeric data in different colors; for example, you can shade data depending on whether the value is greater, equal to, or less than zero. You can also present list data against a background pattern of alternating shades, as in the following example.
To apply alternating shades to the rows of your worksheet, follow these steps:

1. Start Excel, and then open new worksheet.
2. Type the following data in cells A1:D4

       Bob    Smith    Active   555-1111
       Sue    Jones    Retired  555-2222
       Alf    Wilson   Retired  555-3333
       Mary   Morley   Retired  555-4444

3. Select the range A1:G6.
4. On the Format menu, click Conditional Formatting.
5. Under Condition 1, select Formula Is.
6. In the data entry box, type =MOD(ROW(),2)=1.
7. Click the Format button. In the Format Cells dialog box, click the Patterns tab.
8. Select a light-blue color, and then click OK.
9. In the Conditional Formatting dialog box, click OK.

Notice that if you add more data to the list, the conditional formatting is extended to rows beyond row 6. If you want to remove the formatting from unused cells, such as in columns E through G, you can select those cells, and then delete the conditions in the Conditional Formatting dialog box.
NoteIf formatting is not consistently applied after data is entered, use a formula that checks for blanks first. With this approach, however, the formatting does not appear until you enter values. To do this, follow these steps:

1. In Cell A1, type the following conditional formatting formula: =AND(MOD(ROW(),2)=0,A1<>””).
2. Copy this cell to the other cells in your range to be shaded.