Conditional Formatting

• Highlight the cell(s) to which you wish to apply conditional formatting
• choose FORMAT Conditional Formatting
• the Conditional Formatting Dialog Box
  • you are about to set “Condition 1” (you can set more than one condition)
  • the first drop-down box allows you to set a condition based upon the “Cell Value Is” (shown) or the “Formula Is” (not shown).
  • the second drop-down box allows you to set a criteria
    • between (shown)
    • not between
    • equal to
    • not equal to
    • greater than
    • less than
    • greater than or equal to
    • less than or equal to

The Conditional Formatting Dialog Box

• enter the values in the third and fourth boxes (the fourth box will only be available if you select “between” or “not between”
• click theto display the Format Cells Dialog Box (this dialog box is essentially the same as that displayed when you select FORMAT Cells and choose the “Font” tab, click here to review this dialog box)
  • select the type of formatting you desire (font, font size, color, etc.)
  • click
  • the Conditional Formatting Dialog Box reappears and the preview area displays the selected formatting
• you now have two options, you may do one or the other
  • clickto apply the conditional formatting and close this dialog box
  • clickto apply the conditional formatting and then create a second condition
  • Theis used to delete a previously defined conditional format