Forum Discussion
Need to Highlight the range of Dates (Week) where today date is fallen
With conditional formatting
=((B2<$A2)*(C2>$A2)*(MOD(COLUMN(B2),2)=0))+((B2>$A2)*(A2<$A2)*(MOD(COLUMN(B2),2)=1))
Before that, highlight B2:G7 and then Formula in Conditional formatting and select color.
...maybe it will help 🙂
Use conditional formatting to highlight information
=Z1=TODAY()
=WEEKNUM(A1,1)
Please See below table, today date 13-05-2022, which is fallen between 10-05-2022 to 16-05-2022 range in week 2 (Circled).
What I need is a conditional formatting (Green), whenever the date fallen between range of dates. (Weeks).
here is a suggested solution with SUMPRODUCT...I think it fits better :)).
=SUMPRODUCT(($B2:$G2<$A2)*($C2:$H2>$A2)*(MOD(COLUMN($B2:$G2),2)=0))
With conditional formatting
=((B2<$A2)*(C2>$A2)*(MOD(COLUMN(B2),2)=0))+((B2>$A2)*(A2<$A2)*(MOD(COLUMN(B2),2)=1))
Before that, highlight B2:G7 and then Formula in Conditional formatting and select color.
...maybe it will help 🙂
- Thanks - It works.