How to handle comments in Excel 2007

All commands (icons) that deal with comments are found in the Review tab, Comments group.

xl7comments1

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 on the top right corner of the cell.

xl7comments2

To show a comment:

1. Select the cell where you have the comment.
2. Click Show / Hide Comment.
3. If you have multiple comments then you can click Show All Comments to show all.

Note:

If the comment is already shown and you click Show / Hide Comment, then the comment will be hidden.

To edit a comment:

1. Select the cell where you have the comment.
2. Click Edit Comment.
3. The comment box will be shown. Click on it then edit the text.

To format a comment:

1. Select the cell where you have the comment.
2. Click Edit Comment.
3. The comment box will be shown.
4. Select the text that you want to format then right-click.

xl7comments3

5. Form the context menu select Format Comment.
6. in the Format Comment dialog box, select the formatting options that you want.

To move or resize a comment:

1. Select the cell where you have the comment then show the comment as explained previously.
2. Click the border of the comment box to show the sizing handles.
3. To move the comment, drag the border of the comment box, or press one of the arrow keys depending on which direction you want to move.

xl7comments4

4. To resize the comment, drag the handles on the sides and corners of the comment box.
xl7comments5

To copy a comment to another cell:

1. Select the cell where you have the comment.
2. In the Home tab, Clipboard group, click Copy (or just right click on the cell and select copy).
3. In the Home tab, Clipboard group, click the arrow below Paste, then select Paste Special (or just right click on the cell and select Paste Special).
4. In the Paste Special dialog box , under Paste, select Comments then click OK.

To delete a comment:

1. Select the cell where you have the comment.
2. Click Delete Comment.
3. The comment box and the comment indicator will both disappear.

To print a comment:

To print a comment check this post.

Conditional formatting in Excel 2007 (based on value of another cell)

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.

xl7cformat3

4. The New Formatting Rule window will open.

xl7cformat4

5. Click Use a formula to determine which cells to format.
6. The New Formatting Rule window will now look like this:

xl7cformat5

7. In the edit box labeled “Format values where this formula is true“, enter “=” followed by a formula referencing the other cell.

In this example the formula: “=B1<0” is entered.
8. Click the Format button. The Format Cells window will open.

xl7cformat6

9. Specify the formatting you want. In this example I changed the cell color to “RED”.
10. Click OK to close The Format Cells window.

11. Click OK to close The New Formatting Rule window.

To summarize this example: cell A1 will have a RED color when cell B1 value is less than zero.

Conditional formatting in Excel 2007 (based on value of the current cell )

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.

xl7cformat1

4. I will use Greater Than as an example. The Greater Than window will open.

xl7cformat2

5. Enter the value in the text box to the left
6. Select the required formatting from the drop down to the right.
7. Click OK.

How to clear conditional formatting of a cell

  1. Select the cell(s) for which you want to clear conditional formatting.
  2. On the Format menu, click Conditional Formatting.
  3. The Conditional Formatting dialogue will open, and the applied conditions will be listed.
  4. Conditional formatting

  5. Click Delete.
  6. The Delete Conditional Format window will open.
  7. Delete format

  8. Select the condition(s) to delete then press OK.

Applies to: Excel 2003

How to find cells that have conditional formats

If you want to find cells that have conditional formatting, then you have two choices:

1. Find cells with any conditional formatting.

2. Find cells that have conditional formatting settings identical to the settings of a specific cell.

For option 1 do the following:

1. On the Edit menu, click Go To. The Go To window will open

GoTo

2. Click Special. The Go To Special window will open.

gotospecial

3. Click Conditional formats.

4. At the bottom of the window click on the radio button that says All.

All cells with conditional formatting will be highlighted.

For option 2 do the following:

1. Click the specific cell to compare to.
2. On the Edit menu, click Go To. The Go To window will open
3. Click Special. The Go To Special window will open.
4. Click Conditional formats.

5. At the bottom of the window click on the radio button that says Same.

All cells with conditional formatting that matches the selected cell will be highlighted.

How to format a cell based on the value of another cell (conditional formatting)

  1. Select the cells for which you want to add conditional formatting.
  2. On the Format menu, click Conditional Formatting.
  3. The Conditional Formatting dialogue will open.
  4. xcformatf2.gif

  5. In the first combo box select Formula is.
  6. In the text box next to it write the formula as follows: =$A$1<100. An equal sign followed by the cell reference followed by a comparison or a condition.
  7. Click the format button, the Format Cells dialogue will open.
  8. xcformat.gif

  9. Select the formatting you want to apply when the cell value meets the condition e.g. you can set the font color to red.

In this example, if the value of cell A1 is less than 100, then the color of the selected cells will be red.

Applies to: Excel 2003

How to format a cell based on its value (conditional formatting)

  1. Select the cells for which you want to clear the conditional formatting.
  2. On the Format menu, click Conditional Formatting.
  3. The Conditional Formatting dialogue will open, and the applied conditions will be listed.
  4. Click Cell Value Is.
  5. In the combo box next to it select the comparison phrase e.g. less than.
  6. Next enter a constant value (0 in this example).
  7. Click the format button, the Format Cells dialogue will open.

  1. Select the formatting you want to apply when the cell value meets the condition e.g. you can set the font color to red.

Applies to: Excel 2003