SOLVED

Conditonal Formatting in Excel

Copper Contributor

I would like to use two colors for coloring dates that are meetings.  These dates are space out for the last three months. I want to color green for the first year and say red for the year beyond.  I have tried several ways and not getting the same results.  

 

My summary sheet has all formulas and the conditional formatting that I tried did not work the same way.  

 

I have tried several tutorials and not getting the right answers.

P.S. I am using dates. 

 

6 Replies
Select your date range ( assuming as starting in A2) and apply this conditional formatting formulas:
For green:
=A2<=EndOfFirstYear
For red:
=A2>EndOfFirstYear

It did not work

Here is example"  

ABCDEFH
10/18/20186/7/20176/7/2017    
4/9/201911/27/201811/27/201811/29/20183/9/2018  
 10/23/201710/23/201710/24/201710/24/2017  
 8/30/2018 8/30/2018   
       
4/9/20192/1/20192/1/20192/1/2019   

@frontdesksm 

This did not work or I didn't understand the process.   Here is another @Twifoo 

ABCDEF  
        
10/18/20186/7/20176/7/2017     
4/9/201911/27/201811/27/201811/29/20183/9/2018   
 10/23/201710/23/201710/24/201710/24/2017   
 8/30/2018 8/30/2018    
        
4/9/20192/1/20192/1/20192/1/2019    

@frontdesksm 

Please attach your sample file so that it would be easier to test the appropriate conditional formatting formula.

Attach is sample of what I am working with. I want to highlight less than year and red over a year old.

Thank You for your help.

 

 

@Twifoo 

best response confirmed by frontdesksm (Copper Contributor)
Solution

@frontdesksm 

Perhaps

=(A3>EDATE(TODAY(),-12))*ISNUMBER(A3)

for the green and

=(A3<=EDATE(TODAY(),-12))*(A3>1)

for the red, applied  to =$A$3:$I$8

1 best response

Accepted Solutions
best response confirmed by frontdesksm (Copper Contributor)
Solution

@frontdesksm 

Perhaps

=(A3>EDATE(TODAY(),-12))*ISNUMBER(A3)

for the green and

=(A3<=EDATE(TODAY(),-12))*(A3>1)

for the red, applied  to =$A$3:$I$8

View solution in original post