Mar 24, 2015 · When I try to enter the formula I get "This formula is missing a range reference or a defined name. "However both of the following formulas work perfectly, each in turn selecting the correct embedded photo: =B2 | =C2 I tried with the rand function in its own cell but have not been able to enter a formula for the image.. Any help appreciated.
Cell Reference. To create a formula that uses data in certain cells, you’ll need to refer to those cells. In Excel, cell references are given by supplying the column letter and row number. For example, cell C3 exists at the intersection of column C and row 3. Read more about cell reference in Excel. A Simple Formula – AutoSum Another easy way to highlight cells referenced in a formula is to press F2 to edit the cell containing the formula in question. With this technique you get a nice color coded visual of the cells involved: But that’s only good for one cell at a time. Highlight Cells Referenced in Formulas with Conditional Formatting