• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 42
  • Last Modified:

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

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
agwalsh
Asked:
agwalsh
1 Solution
 
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?
0
 
als315Commented:
You can replace >,<,= with nothing and convert value to number. Look at sample
Sample.xlsx
0
 
agwalshAuthor Commented:
Does the job - THANK YOU
0
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.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now