<div>
<div class="content wysiwyg-content">
I have data in a pivot<br />
<br />
Name &nbsp; Jan Feb etc etc Sep &nbsp;Oct Nov<br />
<br />
Dave &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp;0 &nbsp; &nbsp; 1 &nbsp; 1 &nbsp; &nbsp;1 &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp;1<br />
<br />
<br />
I am looking for conditional formatting that will turn a row red if two out of the last three months have a value of 1.<br />
<br />
Thanks
</div>
</div>


I have data in a pivot

Name   Jan Feb etc etc Sep  Oct Nov

Dave      1      0     1   1    1     1      1


I am looking for conditional formatting that will turn a row red if two out of the last three months have a value of 1.

Thanks

Conditional Formatting in a pivot

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.