Excel Spreadsheet Help

Soldato
Joined
19 Feb 2009
Posts
3,373
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;

excelz.jpg


Any pointers? Can clarify further if required. It's a large sheet which goes down to row 42414.

Thanks a bunch in advance. :)
 
You should just be able to do this using conditional formatting.

Have a scout around in the ribbon and apply the conditional formatting that when 10<x<20 highlight the cell a particular colour else leave as normal and just apply it to that particular column.
 
Hmm, I tried that but for some reason it's gone a bit strange on me. This is what I'm doing;

excel1x.jpg


And this is what I'm getting;

excel3i.jpg


I'm starting to think the layout of the numbers is causing it.

Thanks for the help.
 
Why are the numbers to the left of the cell? Are they left aligned or are they being dealt with as strings by excel? If they are strings then that would certainly cause an issue with the conditional formatting.

If they are being dealt with as strings you can use the "=value()" function to extract the number from the cell.
 
Back
Top Bottom