Select the cell that has the formula you want to fill into adjacent cells. For a very large number of ranges we can use the INDEX function instead of the MIN function. Press Alt F11 keys to open the Microsoft Visual Basic For Applications window.
This process activates all the functions or formulas of excel.
2 click AutoFill Handle down to the bottom in column C. Use conditional formatting to make cells automatically change color based on data. Total rows in range. To create a formula with references highlight the cells you want to use then select an empty cell and enter the formula.