To sum times you usually use Excel built-in function SUM. If you have three cells A1, A2 and A3 formatted as time (hh:mm), and you have :
A1 = 02:30
A2 = 10:15
A3 has the formula: =SUM(A1:A2)
then A3 will have the correct values of 12:45.
However if your total times are greater than 24 hours then things get [...]
To find cells that meet a specific criteria, for example cells with conditional formatting or cells which have data validation, proceed as follows:
In the Home tab Editing group click Find and Select.
Click on:
Formulas : to find cells that contain formulas.
Comments : to find cells that contain comments.
Conditional Formatting : to find cells that have [...]
All commands (icons) that deal with comments are found in the Review tab, Comments group.
To insert a new comment:
1. Select the cell where you want to insert the comment.
2. Click New Comment.
3. A new comment will be created. Type the required text then click outside the comment box.
4. The comment box will disappear but a small indicator will show [...]
1. To adjust the column width to fit the current text, move the mouse pointer to the right border of the column until it changes to a cross as shown and then double click on it.
2. To adjust the column width manually, move the mouse pointer to the right border of the column until it changes to [...]
To insert a background image in Excel 2007 follow these steps:
1. Click on the Page Layout tab.
2. In the Page Setup group click Background. The Sheet Background window will open.
3. Switch to the folder where you have the image, select the image and then click Insert.
4. The selected image will show as a background in your sheet.
Note:
When you insert [...]
I have two previous posts on Excel 2007 conditional formatting: One based on cell’s own value and the second based on value of another cell. This post will cover conditional formatting with multiple rules or conditions.
Suppose you have a cell formatted with this rule:
If cell value is less than zero format with Light Red [...]
Excel 2007 cell styles are helpful in giving your worksheet formatting a consistent look and feel. Excel comes with a number of built in styles. If you are not satisfied with those you can still create and modify your own styles. Here is how you can do it:
1. In the Home Tab, Styles group click Cell [...]
To change worksheet tab color in Excel 2007 :
1. Select the tab whose color is to be changed.
2. In the Home tab, Cells group, click on Format.
3. Under Organize Sheets, point to Tab Color and select the color you want.
This is how your tabs will look like:
To format a cell based on the value of another cell follow these steps:
1. Select the cell you want to format, “A1″ in this example.
2. In the Home tab, Styles group, click on Conditional Formatting.
3. Select New Rule.
4. The New Formatting Rule window will open.
5. Click Use a formula to determine which cells to format.
6. The New Formatting Rule [...]
To format a cell based on its value follow these steps:
1. Select the cell you want to format.
2. In the Home tab, Styles group, click on conditional formatting and point to Highlight Cells Rules.
3. A number of rules will show to the right. Select the rule you want to apply.
4. I will use Greater Than as an example. The [...]
