excel conditional formatting at least one
<p>I have a need for conditional formatting in Excel. </p>

<p>I have 5 cols of data with either Yes or No in them</p>

<pre><code>  A     B     C     D     E
1 Yes   No    No    No    No
2 No    Yes   No    No    No
3 No    No    No    Yes   No
</code></pre>

<p>I need to mark a row (or just a field) </p>

<pre><code> - if there is more than one Yes in a row
 - if there is no Yes in a row
</code></pre>

<p>How to?</p>