Excel Magic Trick 1478

Conditional Format Row When Event Code is a Duplicate AND Task = "Special"

DESCRIPTION

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”.

WORKBOOKS

Download “Excel Magic Trick 1469-1481” Excel-Magic-Trick-1469-1481.zip – Downloaded 70 times – 4 MB







Be the first to comment

Leave a Reply