excelisfun | Conditional Formatting for Consecutive Numbers with Logical Formula. Excel Magic Trick 1806 @excelisfun | Uploaded 1 year ago | Updated 14 hours ago
Download Excel File: https://excelisfun.net/files/EMT1806-1808.xlsx
Learn how to conditional format a row in a table when there are consecutive numbers in the weight column.
Topics:
1. (00:00) Introduction
2. (00:05) Intro to next three videos about Consecutive Numbers in a Column
3. (00:25) Conditional Format Row for Consecutive Numbers
4. (01:00) Build Logical Formula using OR function
5. (02:02) Mixed Cell References with Column Locked. This allows Conditional Formatting for the row.
6. (02:52) Paste Logical Formula into Conditional Fo0rmatting dialog box
7. (03:38) Summary, Closing, Video Links