This deep dive into Excel’s Conditional Formatting starts with the essentials of Conditional Formatting and then takes off quickly. Students learn to make interesting data standout using colors, icons or data bars.

Upon successful completion, students will be able to:
• Apply basic conditional formatting
• Format rows/columns based on single/multiple cell values
• Format based on a dynamic date
• Determine duplicate items
• Use the AND/OR functions in formatting
• Understand and apply icon, three/four scale and data bar conditional formatting