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 [...]
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 [...]
Select the cell(s) for which you want to clear conditional formatting.
On the Format menu, click Conditional Formatting.
The Conditional Formatting dialogue will open, and the applied conditions will be listed.
Click Delete.
The Delete Conditional Format window will open.
Select the condition(s) to delete then press OK.
Applies to: Excel 2003
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
2. Click [...]
Select the cells for which you want to add conditional formatting.
On the Format menu, click Conditional Formatting.
The Conditional Formatting dialogue will open.
In the first combo box select Formula is.
In the text box next to it [...]
Select the cells for which you want to clear the conditional formatting.
On the Format menu, click Conditional Formatting.
The Conditional Formatting dialogue will open, and the applied conditions will be listed.
Click Cell Value Is.
In the combo box next to it select the comparison phrase e.g. less than.
Next enter a constant value (0 in this example).
Click [...]
