Insert word in cell based on value in another cell?
Solved/Closed
                    
        
                    doublewitt
    
        
                    Posts
            
                
            14
                
                            Registration date
            Sunday April 27, 2014
                            Status
            Member
                            Last seen
            September 29, 2014
            
                -
                            May  1, 2014 at 01:32 PM
                        
doublewitt Posts 14 Registration date Sunday April 27, 2014 Status Member Last seen September 29, 2014 - May 1, 2014 at 02:06 PM
        doublewitt Posts 14 Registration date Sunday April 27, 2014 Status Member Last seen September 29, 2014 - May 1, 2014 at 02:06 PM
        Related:         
- Based on the values in cells b77
 - Based on the values in cells b77 b81 c77 - Excel Forum
 - Based on the values in cells b77 b81 what function can automatically return the value in cell c77 ✓ - Excel Forum
 - Looking For a Value in a Cell - Excel Forum
 - Based on the values in cells b77 b88 - Excel Forum
 - Instagram account based in wrong country - Instagram Forum
 
2 responses
                
        
                    Mazzaropi
    
        
                    Posts
            
                
            1985
                
                            Registration date
            Monday August 16, 2010
                            Status
            Contributor
                            Last seen
            May 24, 2023
            
            
                    147
    
    
                    
May 1, 2014 at 01:55 PM
    May 1, 2014 at 01:55 PM
                        
                    doublewitt, Good afternoon. 
 
"...CONDITIONAL FORMATTING for cell A2:..."
As the name says, Conditional Formatting only changes the FORMAT of a cell, not the content.
It works the aesthetic aspect of the cell.
For the formula:
A2 --> =IF(C3>500,"alert","")
Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
            "...CONDITIONAL FORMATTING for cell A2:..."
As the name says, Conditional Formatting only changes the FORMAT of a cell, not the content.
It works the aesthetic aspect of the cell.
For the formula:
A2 --> =IF(C3>500,"alert","")
Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
                
        
                    doublewitt
    
        
                    Posts
            
                
            14
                
                            Registration date
            Sunday April 27, 2014
                            Status
            Member
                            Last seen
            September 29, 2014
            
                    
May 1, 2014 at 02:06 PM
    May 1, 2014 at 02:06 PM
                        
                    OK - thanks, works fine