Excel Magic Trick 1478: Conditional Format Row When Event Code is a Duplicate AND Task = "Special"




About this tutorial:

Video duration: 00:08:11
Download Files: Start Excel File:
Entire page with all Excel Files for All Videos: about how to
In this video learn how to use Conditional Formatting to format the row in a data set and how to use the COUNTIFS and AND Functions to create a Logical Formula that will deliver a TRUE when the Event Key is a Duplicate AND the Task Column equals “Special”.

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads