613,629 views
In this video, I will explain how to use conditional formatting in a work flow chart created in Excel without using cell merging. Chiba Yuichi #Excel #Cell Merging #Conditional Formatting #Improve Your Skills #Video Explanation #Formulas #Functions #Business #Working Adult ━━━━━━━━━━━━━━━━━━━━━━━━━━━ ■ File Download ━━━━━━━━━━━━━━━━━━━━━━━━━━ [Members Only] You can download from the link below. • Post ━━━━━━━━━━━━━━━━━━━━━━━━━ ■ Membership ━━━━━━━━━━━━━━━━━━━━━━━━━━ You can check out the member-only benefits from the link below. / @exceldokatach ━━━━━━━━━━━━━━━━━━━━━━━━━━ ■ Meeting place for Excel dokata ━━━━━━━━━━━━━━━━━━━━━━━━━━━ We post videos explaining Excel including Power Query, Power Pivot and DAX. https://excel-dokata.mish.tv/ ▼Latest video at time of posting Power Pivot and DAX practice problems #1004. [Part 3] Creating a comparison table of budgeted and actual results from budget data and performance data 🎞️ Watch at [Members-only video] • #1004. [Part 3] Creating a comparison table of budgeted and actual results from budget data and performance data 🎞️ Watch at [Excel Dokata Meeting Place] https://excel-dokata.mish.tv/en/video... ━━━━━━━━━━━━━━━━━━━━━━━━━━ ■ X (formerly Twitter) ━━━━━━━━━━━━━━━━━━━━━━━━━━━━ We tweet about video updates and the like. / chiba_u1 ━━━━━━━━━━━━━━━━━━━━━━━━━━ ■ Online individual consultation about Excel ━━━━━━━━━━━━━━━━━━━━━━━━━━ Apply for an online individual consultation about Excel using Zoom. https://bit.ly/3IZTwxF ━━━━━━━━━━━━━━━━━━━━━━━━━ ■ Online lessons on Storaka ━━━━━━━━━━━━━━━━━━━━━━━━━━━ Online courses using Zoom where you can learn how to use Excel are held on Storaka. ▼Excel Power Query [Introduction] https://bit.ly/3rrU3gB ▼Excel Power Query [Beginner] https://bit.ly/3cA0UQO ▼Excel Power Pivot [Beginner] https://bit.ly/3cA0UQO ▼Excel Pivot Tables [For beginners] https://bit.ly/36GoKXs ▼List of online courses https://bit.ly/3tvkMKG ━━━━━━━━━━━━━━━━━━━━━━━━━━ ■ Posting articles on note ━━━━━━━━━━━━━━━━━━━━━━━━━━━ I post articles about Excel functions, Power Query, Power Pivot, and DAX. https://note.com/excel_dokata ━━━━━━━━━━━━━━━━━━━━━━━━━━ ■ Business-related inquiries━━━━━━━━━━━━━━━━━━━━━━━━━━ For business-related inquiries such as outsourcing, business commissioning, instructor requests, consulting, private lessons, etc., please contact us here. [email protected] ━━━━━━━━━━━━━━━━━━━━━━━━━━━ ■ Excel version━━━━━━━━━━━━━━━━━━━━━━━━━━━━ The Excel used in the video is Microsoft365 Personal (Office Insider Beta, the latest version at the time of video release). ━━━━━━━━━━━━━━━━━━━━━━━━━━ ■ Timestamps ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ [00:00] Introduction [00:33] Workflow chart [03:15] Unmerging cells [06:40] Conditional formatting [10:23] Determining the rows to be extracted by the filter [14:58] Conclusion