Having Fun with Conditional Formatting | Mimicking Merged Cells…but Better
In this video, we’ll use conditional formatting within Excel to enhance a report so that it has what appears to be dynamically merging cells. The techniques covered in this video will show how to create a report that combines both form and function. The report is easy to read while still being able to take advantage of Excel’s great features like filtering and PivotTables.
Thanks for watching.
🎬 KZread LINKS 🎬
------------
Filling Blank Cells with Above Values in Excel: • Filling Blank Cells wi...
Work Faster in Excel with These 10 Essential Keyboard Shortcuts: • Work Faster in Excel w...
⏱ TIMESTAMPS ⏱
------------
0:00 Introduction
0:51 Outline
1:15 Building the First Equation
2:00 Formatting Duplicates
5:53 Building the Second Equation
8:37 Formatting First Values
10:23 Wrap up
Пікірлер: 7
This is exactly what is was looking for, although I have to do the grouping for multiple columns, this will help. Thanks!
@ExcelSmith
Жыл бұрын
Thanks for the comment. I’m glad it helped.
Thanks for the sharing, your video is presented with amazing contents and further elaborates in alternative solution and advanced skill. Keep it up and I'd followed!
@ExcelSmith
Жыл бұрын
Thank you. I appreciate it.
This is solid
@ExcelSmith
Жыл бұрын
Thank you. I'm glad you like it.
Which Excel version is this