Conditional formatting for a range
Closed
                    
        
                    christieramos
    
        
                    Posts
            
                
            1
                
                            Registration date
            Friday November  8, 2013
                            Status
            Member
                            Last seen
            November  8, 2013
            
                -
                            Nov  8, 2013 at 03:57 PM
                        
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Nov 10, 2013 at 09:42 AM
        rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Nov 10, 2013 at 09:42 AM
        Related:         
- Conditional formatting for a range
 - Excel conditional formatting based on date - Guide
 - How to clear formatting in excel - Guide
 - How to increase wifi range from router settings - Guide
 - Formatting windows 7 - Guide
 - Apple airtags range - Guide
 
1 response
                
        
                    rizvisa1
    
        
                    Posts
            
                
            4478
                
                            Registration date
            Thursday January 28, 2010
                            Status
            Contributor
                            Last seen
            May  5, 2022
            
            
                    766
    
    
                    
Nov 10, 2013 at 09:42 AM
    Nov 10, 2013 at 09:42 AM
                        
                    It should work. Could you share what formula you are using in conditional format?
Some thing like this
=NOT(ISERROR(MATCH(A1,$G:$G,0)))
            Some thing like this
=NOT(ISERROR(MATCH(A1,$G:$G,0)))