Automatically Format Last X Number of Rows - Excel Trick

In this video, we use Conditional Formatting with a formula to automatically format the last x number of rows. The Conditional Formatting rule will format the whole row, and be dependent on two conditions. The number of rows to format will be entered in a cell value. A formula is used which includes AND, ROW, COUNTA and some advanced use of referencing techniques to ensure that the Conditional Formatting works. Find more great free tutorials at; https://www.computergaga.com *** Online Excel Courses *** The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel Excel VBA for Beginners ► http://bit.ly/37XSKfZ Advanced Excel Tricks ► https://bit.ly/3CGCm3M Excel Formulas Made Easy ► http://bit.ly/2ujtOAN Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm Connect with us! LinkedIn ► https://www.linkedin.com/company/18737946/