Conditional Formatting based on year
Solved/Closed
                    
        
                    BrianGreen
    
        
                    Posts
            
                
            1005
                
                            Registration date
            Saturday January 17, 2015
                            Status
            Moderator
                            Last seen
            September 30, 2021
            
                -
                            Feb  2, 2016 at 12:47 PM
                        
BrianGreen Posts 1005 Registration date Saturday January 17, 2015 Status Moderator Last seen September 30, 2021 - Feb 2, 2016 at 01:23 PM
        BrianGreen Posts 1005 Registration date Saturday January 17, 2015 Status Moderator Last seen September 30, 2021 - Feb 2, 2016 at 01:23 PM
        Related:         
- Conditional Formatting based on year
- Excel conditional formatting based on date - Guide
- Excel clear formatting - Guide
- Based on the values in cells b77 b88 - Excel Forum
- Based on the values in cells b77 ✓ - Excel Forum
- Return Seq Values Until Blank value then return different set of seq values ✓ - Excel Forum
1 response
                
        
                    BrianGreen
    
        
                    Posts
            
                
            1005
                
                            Registration date
            Saturday January 17, 2015
                            Status
            Moderator
                            Last seen
            September 30, 2021
            
            
                    149
    
    
                    
Feb 2, 2016 at 01:23 PM
    Feb 2, 2016 at 01:23 PM
                        
                    GOT IT = Wheeeeeee ....
instead of using the "NOW()" command I needed "EDATE()
Substituting "EDATE(TODAY(),-12)" where I had "NOW()-30" does the trick.
The final conditional formatting rules are:
 
Cell value = "." .......... ......... No Format Set ..... Stop If True
Cell Value <EDATE(TODAY(),-12) ...... Green Background
Cell Value >=EDATE(TODAY(),-12) .... Yellow Background
 
                
                
            instead of using the "NOW()" command I needed "EDATE()
Substituting "EDATE(TODAY(),-12)" where I had "NOW()-30" does the trick.
The final conditional formatting rules are:
Cell value = "." .......... ......... No Format Set ..... Stop If True
Cell Value <EDATE(TODAY(),-12) ...... Green Background
Cell Value >=EDATE(TODAY(),-12) .... Yellow Background
