The " cells in the row" would need to reference the "Cell" that contains
the discount %.

Reza wrote:
How can I create a box in excel which would apply to an entire row. What I
mean is I want to create an excel sheet for my sales team where they can give
discounts. I want to have a box to enter to discount % and the whole row
changes. Can anyone help me on this?
Thanxs,
Reza