<div>
You can use this formula:<br />
<br />
=IF(A1&lt;(B1/4),&quot;Yes&quot;,&quot;No&quot;)<br />
<br />
Flyster
</div>


<div>
I might need to change the percentage once in a while to a different value, let say 37%. How would that look like?
</div>


<div>
<div class="content wysiwyg-content">
I have 3 columns (A, B and C) in Excel 2010. I need to put text YES in the C column if A is less than 25% of B and text NO if it is more than 25%. What is the best way to do it?
</div>
</div>


I have 3 columns (A, B and C) in Excel 2010. I need to put text YES in the C column if A is less than 25% of B and text NO if it is more than 25%. What is the best way to do it?

Conditional formatting formula comparing two columns

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