Forum Discussion
Solved
Date Range Conditional format outside the Cells without data
Hi Everyone! I have a problem and it works for a finite set of the date range within the current year but do not when extended to next year. I have to apply conditional formatting on cells rang...
Hi,
You compare separately months and years. For next year month condition id FALSE and YEAR is TRUE, result is FALSE.
I'd suggest to compare full dates like
=AND(H$4>EOMONTH($F5,-1),H$4<=$G5)
Please see attached
Hi,
You compare separately months and years. For next year month condition id FALSE and YEAR is TRUE, result is FALSE.
I'd suggest to compare full dates like
=AND(H$4>EOMONTH($F5,-1),H$4<=$G5)
Please see attached
Hi Sergei, I appreciate. Thanks so much for your help. That really make me understand the date compare concept.
