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

Download Files: Start Excel File: http://ift.tt/2FaY1mx
Entire page with all Excel Files for All Videos: http://ift.tt/1zHY6GI 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”.

View on YouTube

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.