This formula uses this feature to construct a dynamic range based on worksheet input. I would have your tablesranges that you want in the workbook on separate sheets and then setup another tab. First select the entire data from A3E13 as shown below.
Insert and change image dynamically based on the values you entering in a cell.
But sometimes instead of just getting the cell highlighted you may want to highlight the entire row or column based on the value in one cell. Inside the sum function the first reference is simply the first cell in the range that covers all possible cells. Change a cells color based on its current value statically - Once set the background color will not change no matter how the cells value changes. There is no direct way for you to change multiple row heights based on cell value at once but with the following VBA code it can help you to finish this job as quickly as possible.