|
| |
Microsoft Excel
Conditional Formatting
Description
In Microsoft Excel, you can add conditional formatting
to cells so that how a cells looks will change based on specified
conditions. For example, an easy way to see your budget status is to
apply different formatting conditions if you are over budget or if you are
under budget. Once conditional formatting is set up, Excel will
automatically change the cell format based on it's value.
Follow the steps listed below to apply conditional
formatting to a single cell or to a range of cells.
In Microsoft Excel
Menu Path
Conditional Formatting Dialog Box - For Each Condition
-
Click the down arrow next to Cell Value Is
-
Click the down arrow next to the Comparison Phrase
-
Type a Value or a Cell Reference
-
Click the Format button
Conditional Formatting - Conditions
Format Cells Dialog Box
-
Click the Font, Border and/or Patterns tab
-
Select the formatting you want to apply when
the cell value meets the condition
-
Click the OK button
Format Cells Dialog Box
Conditional Formatting Dialog Box - Additional
Conditions
-
Click the Add button to set up to three conditions
-
Repeat the steps to specify the conditions
-
Format each condition as appropriate
-
When finished, click the OK button
-
NOTE: if none of the specified conditions are
true, the cells keep their existing formats. If more than one
condition is true, Microsoft Excel applies only the formats of the 1st true
condition.
Budget Worksheet
with Conditional Formatting on Column C - Actual $
|
