Range Change Colour
Solved/Closed
        Related:         
- Range Change Colour
 - Rj45 colour code - Guide
 - Change lg tv name - Guide
 - Idm language change - Guide
 - Change computer name cmd - Guide
 - Playstation change password - Guide
 
2 responses
                
        
                    rizvisa1
    
        
                    Posts
            
                
            4478
                
                            Registration date
            Thursday January 28, 2010
                            Status
            Contributor
                            Last seen
            May  5, 2022
            
            
                    766
    
    
                    
May 5, 2010 at 06:14 AM
    May 5, 2010 at 06:14 AM
                        
                    You can do it by using conditional format  
Select range A1:E1
goto conditional format
type in formula
=$A$1="lose"
and then click the format button there and choose red color
by the way, if you plan to do same for A2:E2 ....
Then select columns A:E and in conditional format type
=$A1="lose"
and close color red
            Select range A1:E1
goto conditional format
type in formula
=$A$1="lose"
and then click the format button there and choose red color
by the way, if you plan to do same for A2:E2 ....
Then select columns A:E and in conditional format type
=$A1="lose"
and close color red