Lecture 6 - Introduction to conditional formatting-1.pptx - 6 Introduction to Conditional Formatting HM 271 1 Last week Copy\/paste tools Absolute vs

Lecture 6 - Introduction to conditional formatting-1.pptx -...

This preview shows page 1 - 10 out of 34 pages.

6. Introduction to Conditional Formatting HM 271 1
Image of page 1
Copy/paste tools Absolute vs. relative cell references Freeze panes Group/ungroup columns/rows Protect worksheets Last week
Image of page 2
Relative – Absolute ReferenceWhat formula do you need at the cell C5? 3 A.C5/C2B.C5/$C$2C.$C5/$C2D.C$5/C$2
Image of page 3
Relative – Absolute ReferenceWhat formula do you need at the cell C5? 4
Image of page 4
Relative – Absolute ReferenceWhat formula do you need in the cell C17? 5
Image of page 5
Relative – Absolute ReferenceWhat formula do you need in the cell C17? 6
Image of page 6
Today’s objectives Inserting rows and columns Custom Number/Format Conditional Formatting Revise for Exam 1 7
Image of page 7
Conditional Formatting 8
Image of page 8
Conditional Formatting Conditional formatting allows you to automatically apply formatting —such as colors , icons, and data bars —to one or more cells based on the cell value. Examples: Changing the text of a cell to red if a project has gone over budget Insert a colored border around cells that are duplicates Change the color of a row to orange if a project is nearing its deadline Add an icon to highlight any figures that were an improvement on this time last year.
Image of page 9
Image of page 10

You've reached the end of your free preview.

Want to read all 34 pages?

  • Spring '16

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture