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

Excel Magic Trick 1448: Conditional Formatting Formulas: Cell References To “Jump” To Next Template

Download File: http://ift.tt/2smLVzP
Entire page with all Excel Files for All Videos: http://ift.tt/1kSFWvs
See how to create Conditional Formatting for Truck Arrival Dates that shows Blue when truck in unloaded, green when it less than 2 days since arrival, yellow when it is 2 days since arrival and red if it has been more than 2 days since arrival. BUT: the main point on this video is to learn how to use the OFFSET Function, MOD and ROWS functions to create Conditional Formatting Logical Formulas that can be copied to a new template and always see the correct date at the top of the template. This means the conditional formatting can be copied to the side of below and it will always know to read the date at the top of the current Template.

View on YouTube

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.