Cell D3 has value 650 which is greater than 500 so our conditional formatting is applied to the cell. You can use the Paste Special function to multiply a range of cells by a number as follows. If you dont want to use the shortcut keyboard you can use the Fill feature in Excel to apply a formula in an entire column or row.
2 CTRL SHIFT DOWN ARROW to select the column data from the cell where you are.
VLOOKUP The VLOOKUP or Vertical Lookup function is used when data is listed in columns. Conditional formatting of the cell D3. How to use the LOOKUP function in Excel. Due to the use of relative cell references without the sign our Excel multiply formula will adjust properly for each row.