If match is larger than a figure...
Closed
meishapie
-
Aug 12, 2010 at 05:00 AM
rizvisa1
rizvisa1
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Related:
- If match is larger than a figure...
- Facebook says no account match that information ✓ - Forum - Laptop
- We can’t give you access to this account or help with your request until we receive an accepted form of id that matches the info ✓ - Forum - Facebook
- Email doesn't match with any account - Forum - Facebook
- My Facebook ID confirmation - Forum - Facebook
- My Facebook account doesn't exist anymore ✓ - Forum - Facebook
2 replies
rizvisa1
Aug 17, 2010 at 10:52 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Aug 17, 2010 at 10:52 PM
You can use conditional format. You would need two conditions as
=AND(A1=1, B1>2000)
and
=AND(A1=2, B1>3000)
=AND(A1=1, B1>2000)
and
=AND(A1=2, B1>3000)
Thanks for the help! I have one follow-up question:
I understand that conditional formatting only allows 3 conditions but if I have 4 conditions to test, i.e.
A B
1 2356
2 2596
2 3569
1 5096
3 9239
4 22200
and my conditions are "1" should not be more than 2000 and "2" should not be more than 3000, "3" should not be more than 4000 and "4" should not be more than 5000
and all I want is if the data doesn't meet the conditions, the cell should turn red...is there any way to do it without using VBA?
I understand that conditional formatting only allows 3 conditions but if I have 4 conditions to test, i.e.
A B
1 2356
2 2596
2 3569
1 5096
3 9239
4 22200
and my conditions are "1" should not be more than 2000 and "2" should not be more than 3000, "3" should not be more than 4000 and "4" should not be more than 5000
and all I want is if the data doesn't meet the conditions, the cell should turn red...is there any way to do it without using VBA?
rizvisa1
Aug 18, 2010 at 05:26 AM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Aug 18, 2010 at 05:26 AM
For more than 3 conditions then you would need to use a macro
https://ccm.net/forum/affich-21716-conditional-formatting-more-than-3-in-excel#1
https://ccm.net/forum/affich-21716-conditional-formatting-more-than-3-in-excel#1
rizvisa1
Aug 18, 2010 at 07:09 AM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Aug 18, 2010 at 07:09 AM
Well come to think of, since you are only interested in one color, you dont need two conditions
You need one only and that will work for 4 too
=OR(AND(A1=1, B1>2000) , AND(A1=2, B1>3000), AND(A1=3, B1>4000), AND(A1=4, B1>5000))
You need one only and that will work for 4 too
=OR(AND(A1=1, B1>2000) , AND(A1=2, B1>3000), AND(A1=3, B1>4000), AND(A1=4, B1>5000))