6. Introduction to Conditional Formatting HM 271 1
• Copy/paste tools • Absolute vs. relative cell references • Freeze panes • Group/ungroup columns/rows • Protect worksheets Last week
Relative – Absolute ReferenceWhat formula do you need at the cell C5? 3 A.C5/C2B.C5/$C$2C.$C5/$C2D.C$5/C$2
Relative – Absolute ReferenceWhat formula do you need at the cell C5? 4
Relative – Absolute ReferenceWhat formula do you need in the cell C17? 5
Relative – Absolute ReferenceWhat formula do you need in the cell C17? 6
Today’s objectives • Inserting rows and columns • Custom Number/Format • Conditional Formatting • Revise for Exam 1 7
Conditional Formatting 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.
You've reached the end of your free preview.
Want to read all 34 pages?
- Spring '16