Excel TipsTricks Conditional Formatting
Conditional Formatting
In Excel 2000, 2002, 2003
the contents of the cell or b) a formula (which can simply refer to another cell)
Format based on the cell’s
contents
1. Select the cells you want to format (remember you can hold Ctrl to
select contiguous ranges).
2. Choose Format Conditional Formatting.
3. Choose Cell Value Is from the drop-down list.
4. Use the text boxes and drop down lists to create your condition.
5. Click the format button and set the format to apply when the
condition is true.
6. Close the Format dialog box. Click Add if you want to apply more
than one condition to this range of cells. If not, click OK.
Format based on a formula 1. Select the cells you want to format (remember you can hold Ctrl to
select contiguous ranges).
2. Choose Format Conditional Formatting.
3. Choose Formula Is from the drop-down list.
4. Enter an = symbol.
5. Create a formula that evaluates to either True or False. When
creating the formula, create it for the first row and column in the
selected range. You’ll probably need to delete at least one $ from
the cell references.
6. Click the Format Button and set the format to apply when the
condition is true.
In Excel 2000, 2002, 2003
the contents of the cell or b) a formula (which can simply refer to another cell)
Format based on the cell’s
contents
1. Select the cells you want to format (remember you can hold Ctrl to
select contiguous ranges).
2. Choose Format Conditional Formatting.
3. Choose Cell Value Is from the drop-down list.
4. Use the text boxes and drop down lists to create your condition.
5. Click the format button and set the format to apply when the
condition is true.
6. Close the Format dialog box. Click Add if you want to apply more
than one condition to this range of cells. If not, click OK.
Format based on a formula 1. Select the cells you want to format (remember you can hold Ctrl to
select contiguous ranges).
2. Choose Format Conditional Formatting.
3. Choose Formula Is from the drop-down list.
4. Enter an = symbol.
5. Create a formula that evaluates to either True or False. When
creating the formula, create it for the first row and column in the
selected range. You’ll probably need to delete at least one $ from
the cell references.
6. Click the Format Button and set the format to apply when the
condition is true.
