Macro
Closed
                    
        
                    KarenPostell
    
        
                    Posts
            
                
            2
                
                            Registration date
            Wednesday August 17, 2016
                            Status
            Member
                            Last seen
            August 17, 2016
            
                -
                            Aug 17, 2016 at 02:13 PM
                        
KarenPostell Posts 2 Registration date Wednesday August 17, 2016 Status Member Last seen August 17, 2016 - Aug 17, 2016 at 02:18 PM
        KarenPostell Posts 2 Registration date Wednesday August 17, 2016 Status Member Last seen August 17, 2016 - Aug 17, 2016 at 02:18 PM
        Related:         
- Excel macro forum
 - Excel online macros - Guide
 - Excel mod apk for pc - Download - Spreadsheets
 - Excel run macro on open - Guide
 - Kernel for excel repair - Download - Backup and recovery
 - Vat calculation excel - Guide
 
1 response
                
        
                    KarenPostell
    
        
                    Posts
            
                
            2
                
                            Registration date
            Wednesday August 17, 2016
                            Status
            Member
                            Last seen
            August 17, 2016
            
                    
Aug 17, 2016 at 02:18 PM
    Aug 17, 2016 at 02:18 PM
                        
                    Sub What_color ()
Dim Cell as Range
For each cell in range ("a:2:a4955")
If cell.interior.colorIndex = 3
Then cell.value = "red"
Next cell
End sub
            Dim Cell as Range
For each cell in range ("a:2:a4955")
If cell.interior.colorIndex = 3
Then cell.value = "red"
Next cell
End sub