title: Change the Cell Color based on 4 Cells value in Excel
body: <p>I have following table and I want to build a conditional formatting or Macro to highlight the cell value column A if following criteria is not meeting..</p>
  
  <p>if all column values are Yes > all good.. no action required.
  if Column B, C or D value is "No"; check Column A Cell value for "NO"; if it is different, change the background color of Column A Cell value as red.</p>
  
  <p>similarly, if Column B,C, and Column Values are "Yes" but Column A cell value is "NO";  change the background color of Column A cell value as Red.</p>
  
  <p>here is an example:</p>
  
  <pre><code>StablePlan  CaseCount   StockCount  TotalCount
  Yes         Yes         Yes         Yes
  Yes         Yes         No          Yes
  No          Yes         Yes         Yes
  No          Yes         Yes         No
  Yes         Yes         Yes         Yes
  </code></pre>
  
  <p>Currently using (but not working):</p>
  
  <pre><code>=OR($A3="NO",$B3="No",$C3="No",$D3="No")
  </code></pre>