Photo Gallery

Excel Magic Trick 1004: Conditionally Format Row With nth Duplicate, Column Sorted or Not Sorted
Excel Magic Trick 850: Conditional Format More Than 24 Hours (3 Examples)
Excel Magic Trick 1201: Conditional Format Product With No Sales (5 Examples)
Excel Magic Trick 1136: Correlation From 4 Columns: CHOOSE Array Formula “Mash” Columns Together
Excel Magic Trick 1097: AND & OR Criteria Together for Counting, Adding, Conditional Formatting
Excel Magic Trick 1045: Conditionally Format Multiple Modes in a Column, Excel 2010 or Later
Excel Magic Trick 794: Conditional Formatting MAX or MIN or Top 3 Value/s In Row
Excel Magic Trick 1307: Conditionally Format Multiple Non-Adjacent Cells in Cross Tabulated Table
Excel Magic Trick 989: Conditional Formatting For Values above 90% Percentile Mark
Excel Magic Trick 1200: Conditional Format Grades To Assign Icons To 1 of 3 Groups (3 Methods)
Excel Conditional Formatting for a Chess Board or Checkerboard. Excel Magic Trick 1754
Excel Magic Trick 743: Conditional Formatting To Match Items In List On A Different Sheet