Forum Discussion
Solved
Need to Highlight the range of Dates (Week) where today date is fallen
Hi I have a set of dates (7 days) set termed as Week-1,2,& 3. I want to highlight the cell range where today date has fallen. Can you please help WEEK 1 WEEK 2 WEEK 3 18-Dec-21 24-D...
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 🙂
Sameer_Kuppanath_Sultan "Where today's date has fallen". What does that mean? What would you like to highlight in the example data set with today being the 13th of May 2022?