Change colour of range of cells based upon text from a drop down menu in another
Solved/Closed
                    
        
                    Jim1409
    
        
                    Posts
            
                
            1
                
                            Registration date
            Tuesday April 20, 2021
                            Status
            Member
                            Last seen
            April 20, 2021
            
                -
                            Updated on Apr 20, 2021 at 05:29 PM
                        
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Apr 22, 2021 at 11:52 AM
        TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Apr 22, 2021 at 11:52 AM
        Related:         
- Excel change row color based on dropdown selection
- Change cell color based on dropdown selection - Best answers
- How to change row color in excel based on dropdown selection - Best answers
- Notepad++ change background color - Guide
- Saints row 2 cheats - Guide
- Excel color formula - Guide
- Color 65535 - Guide
- Excel mod apk for pc - Download - Spreadsheets
1 response
                
        
                    TrowaD
    
        
                    Posts
            
                
            2921
                
                            Registration date
            Sunday September 12, 2010
                            Status
            Contributor
                            Last seen
            December 27, 2022
            
            
                    555
    
    
                    
Apr 22, 2021 at 11:52 AM
    Apr 22, 2021 at 11:52 AM
                        
                    Hi Jim,
For that we use Conditional Formatting.
First select cells A5:H5. Go to Conditional Formatting found on the Start ribbon and choose to add a rule. Then choose to use a formula (bottom option). Enter the following formula:
=$C5="won"
and apply the green color.
Repeat for the next formula:
=$C5="declined"
and apply the red color.
With A5:H5 still selected, drag the range down as far as you want to apply it to those rows as well.
Best regards,
Trowa
 
                
                
            For that we use Conditional Formatting.
First select cells A5:H5. Go to Conditional Formatting found on the Start ribbon and choose to add a rule. Then choose to use a formula (bottom option). Enter the following formula:
=$C5="won"
and apply the green color.
Repeat for the next formula:
=$C5="declined"
and apply the red color.
With A5:H5 still selected, drag the range down as far as you want to apply it to those rows as well.
Best regards,
Trowa
