Forum Discussion

twwareza's avatar
twwareza
Copper Contributor
Jan 18, 2021
Solved

Formula for conditional format with Months

I have a worksheet like this. The months is a date, but it shows only the month. I used Edate to add one month. 

I am not able to work out how to create the formula to enable the conditional formatting to work properly. ie highlights the months if it falls within the two dates. 

Any tips?

 

Start DateNo DaysEnd Date
   MarApr
01/03/20211011/03/2021  
12/03/2021416/03/2021  
17/03/2021421/03/2021  


Thanks!

Reza

excel

7 Replies

    • twwareza's avatar
      twwareza
      Copper Contributor
      Jan 18, 2021

      Hi big thanks. jukapil 

      I noticed you used endtext ...but the row of months are actually a date, and I just displayed the Month. Would this matter or not?

      I will have a bash at this in the morning. Heading out now. 

      Thanks 

Resources