CODEWITHSUNDEEP
excelexcel-formulaconditional-formatting
sidk
sidk

Reputation: 3

Excel conditional formatting for highlighting the cells

I have wrote a formula for conditional formatting to highlight the days that are overdue from target date! The formula is highlighting everything after the date except for the exact number of days that it is overdue. Any suggestions?

=AND($D6<$F6-(WEEKDAY($F6,2)+1),K$4>=$F6)

sample data Tried highlighting the days overdue, but it highlighted all the days after due date but the days it was supposed to highlight!

Upvotes: 0

Views: 125

Answers (1)

Evil Blue Monkey
Evil Blue Monkey

Reputation: 2609

If you want to cover all the weeks that contains at least one overdue day, try this:

=AND($D6-WEEKDAY($D6,2)+1<=K$4,$F6>=K$4)

Upvotes: 0

Related Questions