Conditional Formatting Based on text and percent criteria
<p>I am trying to figure out how to create a conditional format that will look at the percentage in my field along with if there is text to determine the way the cell is formatted.</p>
<p>To begin I have a formula which determines based on the percentage if it should show a <code>&quot;/&quot;</code> and a number or not. Example below...</p>
<pre><code>=IF(AND(E$21&gt;0,E$21&lt;0.9),(CONCATENATE(TEXT(E$21,&quot;0%&quot;),&quot; / &quot;,(ROUND(E$23,2)))),E$21)
</code></pre>
<p>The current conditional format is below...</p>
<p><code>=IF(OR(ISTEXT(AM9),AM9=0),1,0)</code></p>
<p>And in the OTS Summary picture below you can see this will show the percentage / number in the summary and color it red. I want to update the yellow the same way, but when I input the formula to the yellow it turns the cell white.</p>
<p><img src="https://i.stack.imgur.com/STjrq.png" alt="OTS Summary" /></p>