Comparing 3 columns
Closed
Jose D Chiong
-
Aug 6, 2015 at 07:17 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Aug 8, 2015 at 12:19 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Aug 8, 2015 at 12:19 PM
Related:
- Comparing 3 columns
- Hitman 3 cheats - Guide
- Psiphon 3 download - Download - VPN
- Acer aspire 3 keyboard light - Guide
- Fnia 3 - Download - Adult games
- Xcom 3 - Guide
3 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Aug 6, 2015 at 11:22 AM
Aug 6, 2015 at 11:22 AM
Hi Jose,
So you are looking for the formula's to use with conditional formatting:
1) =AND(D1<D2,D1<D3)
2) =AND(D1>D2,D1>D3)
3) =OR(AND(D1<D2,D1>D3),AND(D1>D2,D1>D3))
You didn't mention any equals, so you might have to add the = symbol on your own.
Best regards,
Trowa
So you are looking for the formula's to use with conditional formatting:
1) =AND(D1<D2,D1<D3)
2) =AND(D1>D2,D1>D3)
3) =OR(AND(D1<D2,D1>D3),AND(D1>D2,D1>D3))
You didn't mention any equals, so you might have to add the = symbol on your own.
Best regards,
Trowa
Hi Trowa,
Thanks for the answer, but I don't get it. Should I write all of the above formula in one cell?
Thanks for the answer, but I don't get it. Should I write all of the above formula in one cell?
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Aug 8, 2015 at 12:19 PM
Aug 8, 2015 at 12:19 PM
Jose D Chiong, Good afternoon.
TrowaD gave you the formulas that you must apply to the rules part at Conditional Format Menu.
Select cells you want to apply Conditional Formatting.
Conditional Format Menu
Using formula
Rule 1
=AND(D1<D2,D1<D3)
Format as Fill with RED color
Rule 2
=AND(D1>D2,D1>D3)
Format as Fill with YELLOW color
Rule 3
=OR(AND(D1<D2,D1>D3),AND(D1>D2,D1>D3))
Format as Fill with BLUE color
OK
Please, tell us if it worked for you.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
TrowaD gave you the formulas that you must apply to the rules part at Conditional Format Menu.
Select cells you want to apply Conditional Formatting.
Conditional Format Menu
Using formula
Rule 1
=AND(D1<D2,D1<D3)
Format as Fill with RED color
Rule 2
=AND(D1>D2,D1>D3)
Format as Fill with YELLOW color
Rule 3
=OR(AND(D1<D2,D1>D3),AND(D1>D2,D1>D3))
Format as Fill with BLUE color
OK
Please, tell us if it worked for you.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão