Conditional Formatting Past Due Dates in Excel! 👶🏻 #excel

Don't waste time spending countless hours on manual, repetitive tasks in Excel 🚫 Join Miss Excel's FREE Masterclass to learn all of her favorite tips & tricks. In this fun power-packed 1 hour session, you'll learn her secret hacks for optimizing your data visualization skills to save you hours each week! Limited spots available! Register at our link in bio 🎉

Place these formulas in another cell to keep original data intact. I used the map formula to highlight the items matching criteria. Enter these formulas to mirror your data range. The "**" indicates items not matching criteria. =MAP(Table8[Mothers Name],Table8[Due Date],LAMBDA(a,b,IF(b<=$HK$1,a,"**"))) =MAP(Table8[Fathers Name],Table8[Due Date],LAMBDA(a,b,IF(b<=$HK$1,a,"**"))) =MAP(Table8[Babys Name],Table8[Due Date],LAMBDA(a,b,IF(b<=$HK$1,a,"**"))) =MAP(Table8[Due Date],LAMBDA(a,IF(a<=$HK$1,a,"**")))