![Excel Conditional Formatting Formulas Excel Formula Learning Resources Formula](https://i.pinimg.com/originals/2e/0f/de/2e0fde9bc71a70d51c30c23bceed9057.png)
Type the first letter of the name and select the name from the list that appears. The whole column is filled with the formula in the cell C6. To create a formula with references highlight the cells you want to use then select an empty cell and enter the formula.
Now select the entire column-This applies even for the Row.
This is the list of numbers in a range or in an array you want to your Number compared to. The Excel COLUMN function returns the column number for a reference. Now select the entire column-This applies even for the Row. Select a cell and enter a formula.