Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Conditional Formatting for Consecutive Numbers with Logical Formula. Excel Magic Trick 1806

Posted on by Annie D

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

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.

ExcelIsFunWed, December 7, 2022 6:38pm