excelf.png

<div>
I apologize about this late reply. &nbsp; I've spent some time breaking down your suggestions. &nbsp; Subodah's code worked well for me. &nbsp; <br />
<br />
Thanks to both of your for your patience and expertise.
</div>


I apologize about this late reply.   I've spent some time breaking down your suggestions.   Subodah's code worked well for me.  

Thanks to both of your for your patience and expertise.

<div>
You're welcome. Glad we could help.
</div>


<div>
<div class="content wysiwyg-content">
I need to figure out how,<br />
<br />
If Q5 = 15 and M5 is at least 30% and below 35%, color cell M5 orange. &nbsp; If Q5 = 15 and M5 is at least 35% and below 45%, color cell M5 blue. &nbsp;If Q5 = 15 and M5 is 45% or above, color cell M5 green.
</div>
</div>


I need to figure out how,

If Q5 = 15 and M5 is at least 30% and below 35%, color cell M5 orange.   If Q5 = 15 and M5 is at least 35% and below 45%, color cell M5 blue.  If Q5 = 15 and M5 is 45% or above, color cell M5 green.

Excel Calculation

color

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

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.