 Shading Cells Based on Whether the Value in the Cell is Odd or Even
Summary: If you have a series of values in a range of cells, you can use Conditional Formatting to distinguish the odd numbers from the even numbers. Here is how to do this:
- Select the cells that contain the odd and even values.
- Select Conditional Formatting from the Format menu. Excel displays the Conditional Formatting dialog box.
- Use the left-most drop-down list and choose Formula Is.
- In the formula area, enter =MOD(A1,2)=1. This formula will return True if the cell contains an odd value.
- Click on Format and change the format to reflect the formatting you want applied to the cells containing odd values. Click on the button In the Conditional Formatting dialog box.
- Repeat steps 3 through 5 for the second condition, but this time use the formula =MOD(A1,2)=0. This condition returns True if the cell contains an even value.
- Click on OK to apply the conditional formats to the cells.
When this conditional formatting applied, if the cell is odd it will be one color and if even it will be another. If the cell contains text, the cell will not be colored; it will have the color of the cell before you added the conditional formatting. The conditional formatting takes precedent over any formatting you applied to a cell, so even if you try to change the cell color via the toolbar, the conditional formatting takes precedent.
Quickly Inserting the Date into a Worksheet
Summary: There are many times when you need to insert the date into a cell in a worksheet.Here's an Excel shortcut that will do that very quickly:
Select the cell where you want to enter today's date. Hold down the Ctrl key while you press the ; (Semi colon key) on your keyboard. Excel will enter today's date into the cell.
Going to the Corners of a Selected Range
Once you have selected the range, hold down the Ctrl key while you press the period key. Excel will move you around the outside corners of the range, in order.
In addition, you can move from the upper-left corner of the selection to the lower-right corner by pressing Shift+Tab once. To move back (from bottom-right to upper-left), just press the Tab key once.
|
Summary: Word has a variety of standard page numbering formats. However, you are not restricted to these formats. You can format page numbers exactly the same as you format any other text in your document. Here is how to do this:
- Your first step, of course, is to insert the page numbers in either the header or footer.
- When you are working in the Print Layout view, you can double-click on the header or footer, select the page number, and manually format it.
- You format the page numbers exactly the same as you format any other text in your document. For example, you can make the page numbers bold, italic, change their size, etc.
However, if you are in the Draft or Outline view, you will have to switch to the Print Layout view before you can edit the header or footer. (If you use the Header and Footer tools on the Insert tab of the ribbon in order to access the header or footer, Word switches you to the Print Layout view automatically.)
|
