?
Solved

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

Posted on 2016-08-16
3
Medium Priority
?
38 Views
Last Modified: 2016-08-16
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 :-)
0
Comment
Question by:agwalsh
3 Comments
 
LVL 33

Expert Comment

by:Subodh Tiwari (Neeraj)
ID: 41757479
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?
0
 
LVL 40

Accepted Solution

by:
als315 earned 2000 total points
ID: 41757482
You can replace >,<,= with nothing and convert value to number. Look at sample
Sample.xlsx
0
 

Author Closing Comment

by:agwalsh
ID: 41757628
Does the job - THANK YOU
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question