Z
Zorro
I have a large order form as follows:
Col A : Product Code, Col B: Description, Col C: Quantity.
As I move throught the cells in the quantity column I would like the
adjacent cells in columns A and B (or the whole row if necessary) to be
highlighted in, say, yellow. When I move away from the row in question, that
row would no longer be highlighted.
The reasoning is to ensure the correct product is ordered when a value is
entered in Col C.
Many thanks,
Zorro
Col A : Product Code, Col B: Description, Col C: Quantity.
As I move throught the cells in the quantity column I would like the
adjacent cells in columns A and B (or the whole row if necessary) to be
highlighted in, say, yellow. When I move away from the row in question, that
row would no longer be highlighted.
The reasoning is to ensure the correct product is ordered when a value is
entered in Col C.
Many thanks,
Zorro