Dynamic Colour Coding for Task Status Tracking in Microsoft Excel
Many people use Microsoft Excel with manual colour coding. This allows them to visually see the status by different colours. There is one obvious limitation is different person has different preference of same colour, e.g. light green vs dark green.
Watch this video to learn how to make such colour coding automatic and very easy to use.
0:00 The end result
0:19 The Intro
0:25 Pre-Work: Creating Excel Table with Meaningful Name
2:26 Prepare Aesthetic Appearance by Turning off Banded Rows and Gridlines
2:47 Creating Dynamic Dropdown List (Data Validation)
3:26 Creating Dynamic Colour Coding by Different Status (Conditional Formatting)
6:05 Duplicating Conditional Formatting Rule for Different Status
6:55 Testing Dynamic Colour Coding with Status Update and New Task
8:21 Appreciation Note
Download eBook: The 5 Magic to Master Business Data
👉 https://5-secrets-biz-data.mailerpage...
Follow Me in Odyess
👉 https://odysee.com/@ExcelSifu
Join Me in Odyess
👉 https://odysee.com/$/invite/HuxeoXKaU...
Connect to me in LinkedIn
/ excelsifu
Like our Facebook
/ whyexcel
Hash Tag
#ExcelSifu #MicrosoftExcel #TaskTracking