Okay, I need help sorting out an Excel Spreadsheet I've been given. It sounds fairly simple like, but haven't used Excel for over a year so I need a hand in figuring it out.
Basically, there's a new price and an old price. I only need to be looking at the changes in price that go over or under £20. So for example, old price 30 new price 10 so the price change would be -20. All the prices changes over 20 either way must be highlighted. I was first thinking of a button which when pressed would go to the next cell in that column which contains a price change 20 or over. Does that sound about right?
Here's a small snippet of the sheet;
Any pointers? Can clarify further if required. It's a large sheet which goes down to row 42414.
Thanks a bunch in advance.
Basically, there's a new price and an old price. I only need to be looking at the changes in price that go over or under £20. So for example, old price 30 new price 10 so the price change would be -20. All the prices changes over 20 either way must be highlighted. I was first thinking of a button which when pressed would go to the next cell in that column which contains a price change 20 or over. Does that sound about right?
Here's a small snippet of the sheet;
Any pointers? Can clarify further if required. It's a large sheet which goes down to row 42414.
Thanks a bunch in advance.
