Microsoft 77-427 - Excel 2013 Expert Part One

Step 1:Drag the Date field to the Filters area.

Step 2:Click on Date in the Pivot table, select 8-Apr-13, and click OK.

Step 3:Click on Date in the Pivot table, select 9-Apr-13, and click OK.

Step 4:Click on Date in the Pivot table, select 10-Apr-13, and click OK.

Step 5:Click on Date in the Pivot table, select 11-Apr-13, and click OK.

Step 5: Click on Date in the Pivot table, select 12-Apr-13, and click OK.

Step 1: On the Home tab select Conditional Formatting, and click Manage Rules.

Step 2: In the Conditional Formatting Rules Manager, select Show formatting rules for: This worksheet,click on the fourth rule Red Text with Strikethrough, and click Edit Rule.

Step 3:Change the formula to=$E5<"7:00:00"and click OK