Ultimate Selector
Board Regular
- Joined
- Dec 15, 2013
- Messages
- 153
I want to format 4 cells that are all negative in value. High lighting will only happen if all are (-) neg... If there is 1 positive number within the 4 then no format or highlighting can take place.
What would be the formula for this? ... Say using A1:D1?
Thanks in advance!
Here are my numbers ... These should all be high lighted but ONLY if all are neg.
Here is another example when no high lighting should take place because there is only 1 negative and 3 positive values.
What would be the formula for this? ... Say using A1:D1?
Thanks in advance!
Here are my numbers ... These should all be high lighted but ONLY if all are neg.
-0.9 | -2% | -5% | -3% |
Here is another example when no high lighting should take place because there is only 1 negative and 3 positive values.
0.7 | -3% | 1% | 4% |