5 *Must have* Excel Conditional Formatting Tricks
52.1 هزار بار بازدید -
4 سال پیش
-
My love affair with Excel
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-condi...
to download the example workbook or know more about these tricks.
#ExcelTricks #ConditionalFormatting
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-condi...
to download the example workbook or know more about these tricks.
#ExcelTricks #ConditionalFormatting
4 سال پیش
در تاریخ 1399/11/27 منتشر شده
است.
52,137
بـار بازدید شده