Excel Conditional Formatting for a Chess Board or Checkerboard. Excel Magic Trick 1754

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1754.xlsx
Learn how to create a logical formula to apply conditional formatting like a chess board or checker board.
(00:00) Introduction
(00:30) ROWS & COLUMNS functions.
(02:28) MOD function to get remainder.
(03:09) Conditional Formatting dialog box
(04:24) Summary

ExcelIsFunFri, September 17, 2021 7:46pm