Conditional formatting between 2 different columns
Closed
Rob P.
-
Sep 6, 2016 at 06:54 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Sep 7, 2016 at 11:29 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Sep 7, 2016 at 11:29 AM
Related:
- Conditional formatting between 2 different columns
- Tentacle locker 2 - Download - Adult games
- Fnia 2 - Download - Adult games
- Euro truck simulator 2 download free full version pc - Download - Simulation
- Feeding frenzy 2 download - Download - Arcade
- Resident evil 2 remake free download - Download - Horror
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Sep 7, 2016 at 11:29 AM
Sep 7, 2016 at 11:29 AM
Rob P., Good afternoon.
In this case you should create a different formula for each case.
Example case 1:
"...If A1 is 2 and B1 is between 1-341, B1 should be Red..."
Try to do:
Select cell B1
CF MENU --> NEW RULE --> USING FORMULA
Type it at field: =E(A1=2;B1>=1;B1<=341)
Choose RED as fill format
OK
Do the same with others cases.
Please, tell us if it works for you.
--
Belo Horizonte, Brasil.
Marcílio Lobão
In this case you should create a different formula for each case.
Example case 1:
"...If A1 is 2 and B1 is between 1-341, B1 should be Red..."
Try to do:
Select cell B1
CF MENU --> NEW RULE --> USING FORMULA
Type it at field: =E(A1=2;B1>=1;B1<=341)
Choose RED as fill format
OK
Do the same with others cases.
Please, tell us if it works for you.
--
Belo Horizonte, Brasil.
Marcílio Lobão