General discussion


Excel Conditional Formatting: Error when symbols in number cells?

By SeekingAnswers99 ·
Hi Tech Republic,
I would like to make red the cells that satisfy two rules, where Column A >3.5 AND Column B > 75.
Using the formula =AND(A1>3,B1>75) in CONDITIONAL FORMATTING works for all my cells that are just numbers.
However any cell that has a symbol ("less than" or "greather than") is also turned RED even though .....<0.1, .....<1, ..... are not greater than 3.5.

Can you help correct this issue?

Column A Column B
Limit Limit
3.5 75

2 50
3 50
4 50
2 100
3 100
4 100 Red
5 100 Red
.....< 0.1 100 Red but shouldn't be
.....< 1 100 Red but shouldn't be
.....< 3 100 Red but shouldn't be

PS. for some reason the formatting and < symbols disappear when uploaded to your page? the "....." are designated as the "less than" symbol!

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

Try posting as a question

by GSG In reply to Excel Conditional Formatt ...

Try reposting this in the 'Q&A' forum. The 'Discussion' forum is for matters of
general discussion, not specific problems in search of a solution. The 'Water Cooler' is for non-technical discussions. You can submit a question to 'Q&A' here:;content

There are TR members who specifically seek out problems in need of a solution. Although there is some overlap between the forums, you'll find more of those members in 'Q&A' than in 'Discussions' or 'Water Cooler'.

Be sure to use the voting buttons to provide your feedback. Voting a '+' does not necessarily mean that a given response contained the complete solution to your problem, but that it served to guide you toward it. This is intended to serve as an aid to those who may in the future have a problem similar to yours. If they have a ready source of reference available, perhaps won't need to repeat questions previously asked and answered. If a post did contain the solution to your problem, you can also close the question by marking the helpful post as "The Answer".

Collapse -


by rouschkateer In reply to Excel Conditional Formatt ...

You aren't "searching" for the < and > signs in your statement. It would have to include the symbols. Use an IF statement instead.

Related Discussions

Related Forums