Quick Excel Tip: Highlight Weekends with 1 Formula

Channel:

Office Expert

Subscribers:

50,400

Published on April 25, 2025 5:27:33 AM ● Video Link: https://www.youtube.com/watch?v=BRJRG6xpLmo

Duration: 0:29

15,187 views

315

Don’t waste time manually checking for Sundays in Excel! In this short, I’ll show you a super easy trick using Conditional Formatting and a simple formula to automatically highlight all Sundays in your dataset.

✅ Formula used: =TEXT(E3,"dddd")="Sunday"
(Adjust E3 based on your selected range)
This trick works great for planners, schedules, and attendance sheets!
If you found this helpful, give it a like and follow for more quick Excel tips!
#ExcelTips #ExcelShorts #ConditionalFormatting #ExcelTricks #ExcelHack #MicrosoftExcel #ProductivityTips #ExcelMagic #ExcelAutomation #SpreadsheetSkills
--------------------------------------------------------------------------------------
We'd love to hear from you if you have any questions or collaboration proposals!
📧 Our Email: TechAiCenter1@gmail.com
♪ Tiktok: https://www.tiktok.com/@techai71