My love affair with Excel Conditional Formatting began almost 12 years ago when I first used it to create an awesome project plan. In this video let me share some of my favourite secrets about it. You will learn,
0:00 - Introduction
0:45 - Icons, but not too many
3:28 - Highlight entire row
5:31 - Zebra shading, advanced zebra shading
9:55 - Relative dates (dates before today, next week or last week)
13:17 - Databars & Icons in the same cell
Please visit https://chandoo.org/wp/5-useful-conditional-formatting-tricks/
to download the example workbook or know more about these tricks.
#ExcelTricks #ConditionalFormatting
