5 *Must have* Excel Conditional Formatting Tricks

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

• #science_technology
• #chandoo
• #chandooorg
• #excel
• #spreadsheets
• #excel_conditional_formatting_tricks
• #conditional_formatting
• #microsoft_excel
• #databars_and_icons_in_the_same_cell
• #customize_excel_icons
• #highlight_entire_row_with_conditional_formatting
• #how_to_highlight_entire_row_in_excel
• #highlight_dates_in_next_week_in_excel
• #highlight_dates_before_today_in_excel
• #zebra_shading_with_excel
• #highlight_alternative_rows_in_excel
• #excel_2016