Excel Magic Trick 1510: Conditional Format Row With Duplicates Based on Product & Color

Download Files: https://ift.tt/2LQIbEp
Entire page with all Excel Files for All Videos: https://ift.tt/1kSFWvs

In this video see how to color a row with conditional formatting using the COUNTIFS function, an Expandable Range and a Comparative Operator to convert formula to a Logical Formula. See how to use the Conditional Formatting Dialog Box with a Logical Formula. Also see how to use Conditional Formatting on an Excel Table, so new rows are formatted when new records are added..

View on YouTube