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 ► [ Ссылка ]
Automatically Format Last X Number of Rows - Excel Trick
Теги
Microsoft Excelconditional formatting in excelconditional formatting with multiple conditionsconditional formattingcomputergagarow functionexcel tricksconditional formatting with formula in excelalan murrayexcel tricks advancedconditional formatting whole rowadvanced excel tutorialadvanced excel formulas and functionscomputer gagaexcel 365excel tipsconditional formatting based on another cellconditional formatting between two values