title: Highlight Duplicate Rows When Conditions Met in Multiple Columns i Excel
body: <p>I am looking for help setting up a conditional formula in Excel that highlights a row when two conditions are met. The goal is to flag when multiple users are working in the same zone at the same time.</p>
  
  <p>In dataset below, I want to highlight when both conditions are met: the status is "IN PROGRESS", and there are multiple rows in the same zone.</p>
  
  <p>I would like to see row [3] and row [9] highlighted because Jenny and Steve are both "IN PROGRESS" in zone "2".</p>
  
  <p>What I would like to see</p>
  
  <p><img src="https://i.stack.imgur.com/Zix3q.png" alt="What I would like to see"></p>
  
  <p><code>=AND($B1 ="IN PROGRESS", COUNTIF($A:$A,$A1)&gt;1)</code></p>
  
  <p>I have tried different combinations of AND, COUNTIF, and COUNTIFS but am always getting row [7] highlighted because it is "IN PROGRESS" and there are other rows in zone 1 even though none of them are in progress. Thank you for any help.</p>
  
  <p>What I am seeing</p>
  
  <p><img src="https://i.stack.imgur.com/bBSUW.png" alt="What I am seeing"></p>