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
 - 텐타클 락커 2 - Download - Adult games
 - Tweetdeck larger columns - Guide
 - My cute roommate 2 - Download - Adult games
 - Fnia 2 - Download - Adult games
 - Feeding frenzy 2 download - Download - Arcade
 
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