Hi there,
I have a table (like GANTT chart) where I use conditional formatting to highlite the respective periods.
=AND(Q$2>=$G4;Q$2<=$H4)
Row 2 are calendar weeks in a row
Column G is begin CW and H is end CW.
What I find it strange is that in some areas the formatting works as supposed to (area AW39:BG46), BUT in some others it is not (e.g. area S25:AL38, ESPECIALLY row 35).
In both areas the formulas are similar - only difference is the required Colors.
Could someone please take a look, I am struggling with this one since last week. The table is attached.
Thanks in advance
Yulia
Bookmarks