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

If I have numbers entered as following..
Excel sees them as 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 :-)
Who is Participating?
als315Connect With a Mentor Commented:
You can replace >,<,= with nothing and convert value to number. Look at sample
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
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?
agwalshAuthor Commented:
Does the job - THANK YOU
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.