Conditional formatting in excel v2

Conditional formatting in excel v2

• 1.
  Conditional formatting inExcel Next Slide
• 2.
  Conditional Formatting • Makesspreadsheets of complex data easier to read by formatting cells based on the data contained. Next Slide
• 3.
  Highlight text incells Click here for Conditional Formatting options Home tab Highlight column to apply formatting to
• 4.
  Cursor over option HighlightCell Rules
• 5.
  As the column contains text,click Text that Contains….
• 6.
  Type text toformat in this box Click here to choose formatting
• 7.
  Choose the optionfor how you want to format the data
• 8.
  Click OK
• 9.
  All of thecells within the highlighted range now have the chosen formatting Click here to go to next example
• 10.
  Colour scales Highlight column you wishto format Click Conditional Formatting
• 11.
  Put cursor overthe Color Scales option
• 12.
  Put cursor over formatting option
• 13.
  Text is displayed to show the formatting which will be chosen if this is applied. Select More Rules to have more control over how formatting will appear
• 14.
  Options to format the cells Format Style Options Colour of formatting can be chosen Value on which to carry out the Click OK to finalise formatting formatting
• 15.
  Three colour formatting based onthe value compared to other cells in the range Click here to find out how to cancel formatting
• 16.
  Cancelling rules Click Conditional Formatting
• 17.
  Cursor over Clear Rules
• 18.
  Select Clear Rules from EntireSheet
• 19.
  Formatting on the sheet clears Click here to end show