Formula-driven conditional formats automatically adjust in the same way as other formulas when they are filled down. Therefore, assuming that your data starts in cell AB4, the correct formula will be: =AB3>=80
This formula will be automatically adjusted for each cell below the first cell that it is applied to. That means in cell AB5 the formula will be =AB4>=80, in cell AB6 it will be =AB5>=80, and so on: always checking whether the cell above is greater than 80.
If this isn't working, it's likely that either the formula or the cells it has been applied to are incorrect. You can check this by using the Conditional Formatting Rules Manager found under Home > Conditional Formatting > Manage Rules.
You can see the rules manager in action in the video lesson: Essential Skills Lesson 4-16 Manage multiple conditional formats using the Rules Manager.
Jonathan is part of the professional team who answer Excel-related questions posted on the ExcelCentral.com forums.
Jonathan also tests our courses prior to publication and has worked on all of our ten world bestselling Excel books for Excel 2007, Excel 2010, Excel 2013, Excel 2016 for Windows and Excel 2016 for Apple Mac. Jonathan has also worked on over 850 video lessons for or video courses covering Excel 2007, Excel 2010 and Excel 2013.
As well as extensive Excel knowledge, Jonathan has worked in the IT world for over thirteen years as a programmer, database designer and analyst for some of the world's largest companies.