Conditional Format help
Closed
                    
        
                    jamie_ut
    
        
                    Posts
            
                
            1
                
                            Registration date
            Tuesday July 11, 2017
                            Status
            Member
                            Last seen
            July 11, 2017
            
                -
                            Jul 11, 2017 at 10:53 AM
                        
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jul 11, 2017 at 11:31 AM
        Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jul 11, 2017 at 11:31 AM
        Related:         
- Conditional Format help
- Kingston format utility - Download - Storage
- Dvi format - Guide
- Swissknife format - Download - Storage
- Lg tv subtitles format - Guide
- Hp usb disk storage format tool - Download - Storage
1 response
                
        
                    Mazzaropi
    
        
                    Posts
            
                
            1985
                
                            Registration date
            Monday August 16, 2010
                            Status
            Contributor
                            Last seen
            May 24, 2023
            
            
                    147
    
    
                    
Jul 11, 2017 at 11:31 AM
    Jul 11, 2017 at 11:31 AM
                        
                    jamie_ut, Good afternoon. 
 
Suppose:
A2 --> Start date
B2 --> Date 30 days after Start Date
C2 --> Date 60 days after Start Date
D2 --> Date 90 days after Start Date
Try to use:
a) Select B2:D2
b) Conditional Format
Using formula
--> =TODAY()>=B2
--> Format: Fill color RED
OK
Please, tell us if it worked as you desired.
            Suppose:
A2 --> Start date
B2 --> Date 30 days after Start Date
C2 --> Date 60 days after Start Date
D2 --> Date 90 days after Start Date
Try to use:
a) Select B2:D2
b) Conditional Format
Using formula
--> =TODAY()>=B2
--> Format: Fill color RED
OK
Please, tell us if it worked as you desired.
