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;
[ Ссылка ]

*** Online Excel Courses ***

The Ultimate Excel Course – Learn Everything ► [ Ссылка ]
Excel VBA for Beginners ► [ Ссылка ]
Advanced Excel Tricks ► [ Ссылка ]
Excel Formulas Made Easy ► [ Ссылка ]
Creating Sports League Tables and Tournaments in Excel ► [ Ссылка ]

Connect with us!

LinkedIn ► [ Ссылка ]
Instagram ► [ Ссылка ]
Twitter ► [ Ссылка ]

свернуть