<div>
Is there any role of comparative operators or you are concerned only with the number?<br />
Why not post a small sample workbook with desired output mocked up manually?
</div>


Is there any role of comparative operators or you are concerned only with the number?
Why not post a small sample workbook with desired output mocked up manually?

Sample.xlsx

<div>
<div class="content wysiwyg-content">
If I have numbers entered as following..<br />
&gt;50<br />
&lt;=100<br />
Excel sees them as text...how can apply conditional formatting so that Excel will highlight the numbers that are greater than 250. Currently I'm thinking there isn't a straightforward way but want to see if I'm wrong :-)
</div>
</div>


If I have numbers entered as following..
>50
<=100
Excel sees them as text...how can apply conditional formatting so that Excel will highlight the numbers that are greater than 250. Currently I'm thinking there isn't a straightforward way but want to see if I'm wrong :-)

Conditional formatting for numbers where it's mixed with text...

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