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

agwalsh
agwalsh used Ask the Experts™
on
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 :-)
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Subodh Tiwari (Neeraj)Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015

Commented:
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?
You can replace >,<,= with nothing and convert value to number. Look at sample
Sample.xlsx

Author

Commented:
Does the job - THANK YOU

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial