Excel 2013: Conditional Formatting with a Formula on a Column

Microsoft Excel 2013 enables users the ability to apply Conditional Formatting using a formula to define the cells to format. This video will focus on implementing Conditional Formatting for the Total Pay column of a Weekly Payroll Report based on a formula that calculates overtime.

Instruction by
Travis Holt, MOS Master

All Videos

• 

  

  4:38

  Word 2013

  Insert Footer with a Different First Page

• 

  

  6:11

  Word 2013

  Letter Mail Merge with an Excel Recipient List

• 

  

  4:44

  Excel 2013

  Conditional Formatting Top/Bottom Percent Column

• 

  

  5:27

  Excel 2013

  Conditional Formatting with a Formula on a Column

• 

  

  3:07

  PowerPoint 2013

  Insert SmartArt Graphic

• 

  

  3:05

  PowerPoint 2013

  Insert Row in Table

• 

  

  4:33

  Access 2013

  Create Table Relationships

• 

  

  7:11

  Access 2013

  Create User Tables

• 

  

  2:23

  Word 2010

  Screenshot Feature

• 

  

  7:47

  Word 2010

  Macro Applies Font and Line Spacing

• 

  

  3:05

  Word 2010

  Page Border and Drop Cap

• 

  

  5:31

  Excel 2010

  Average and Sum Functions

• 

  

  5:06

  Excel 2010

  VLookup Function

• 

  

  4:21

  Excel 2010

  Filters

• 

  

  5:07

  PowerPoint 2010

  Simple Transitions and Animations

• 

  

  3:15

  PowerPoint 2010

  Animation with Audio Clip

• 

  

  1:59

  PowerPoint 2010

  SmartArt Graphic

• 

  

  8:51

  Access 2010

  Make Table Query

• 

  

  6:06

  Access 2010

  Select Query with Revenue Calculation

• 

  

  5:31

  Access 2010

  Update Query for Product Prices