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, .....<3 are not greater than 3.5.
Can you help correct this issue?
Thanks
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!
