Excel Cell Formatting Solutions
18 videos • 1,005 views • by Caripros HR Analytics
This playlist contains videos on using Excel to solve cell formatting problems in a time-saving manner. Macro/VBA may be used but are not required.
1
How to Automatically Hide Rows based on Cell Value - Macro for Beginner
Caripros HR Analytics
Download
2
How to create a Gantt Chart in 1 click and highlight Weekends and Holidays
Caripros HR Analytics
Download
3
How to Automatically Hide Rows based on Formula driven Cell Value
Caripros HR Analytics
Download
4
How to Automatically Hide Rows based on Cell Value - Formula-driven and Multiple Criteria
Caripros HR Analytics
Download
5
How to Automatically Hide Nonsequential Rows based on Cell Value - Macro for Beginner
Caripros HR Analytics
Download
6
How to Count Colored Cells with Macro in 1 Click
Caripros HR Analytics
Download
7
How to Format Banded Rows Manually (2 Ways)
Caripros HR Analytics
Download
8
Auto-Refresh Pivot Table and Freeze Format in 1 Click - Macro for Beginner
Caripros HR Analytics
Download
9
Advanced Conditional Format in 1 Click - Excel Macro for Beginner
Caripros HR Analytics
Download
10
How to Format Table Border with Macro
Caripros HR Analytics
Download
11
Data Validation: Auto-track cell content change instantly with conditional formatting
Caripros HR Analytics
Download
12
How to create a dynamic Waffle Chart - Simple Method
Caripros HR Analytics
Download
13
Macro for Beginner: How to Automatically Format Cell based on Cell Value in 1 Click
Caripros HR Analytics
Download
14
How to Display Custom Number Format in Concatenated Texts
Caripros HR Analytics
Download
15
Data Validation: Auto-track formula-driven data change with conditional format
Caripros HR Analytics
Download
16
Data Validation: Auto-track formula-driven data change with conditional format [Excel 2010 & above]
Caripros HR Analytics
Download
17
How to Fill Customized Cell Color based on Content with Macro
Caripros HR Analytics
Download
18
Conditional Format with Data Bar and Customized Criteria
Caripros HR Analytics
Download