Conditional Formatting for previous cell change

Hi

In Excel 2013, I want to have a conditional formatting which gives the up/down arrows based on whether the value is higher or lower than the cell before it.

EG

10th Feb 1000
11th Feb 2000

will give a green up arrow by 11th Feb as it's higher than the previous cell.

What formula do I use to do this?

Also I then want to be able to use conditional formatting to highlight the cell red or green depending on whether the values are among the lowest 10%. But then I want to be able to automatically count the number red cells so I can tell by looking at one number on how many days the values have been in the lowest/highest 10%. How can this be achieved and what formula do I need?

So in the same row of data I'm after two sets of conditional formatting.

Thanks,

Ok but for the first one I have lots of data for each day of each month in my real sheet (which contains company info so I can't share).

As an example

10 Feb 1000
11 Feb 2000 Green arrow up
12 Feb 3000 Green arrow up
13 Feb 1500 Red arrow down
14 Feb 2000 Green arrow up
15 Feb 3500 Green arrow up

But I need each one to be automatic so if I suddenly changed 3000 to 500 then the Green arrow up would become a red arrow down based on the previous value.

What I'm after is the formula that depends on the previous cell value.

Thanks

Yep that's what I'm after. Could you guide me through how to do it as I need to apply it to my sheet and I've tried copying the forumlas across but it didn't work

Ok I've uploaded a sample of my sheet. Please can you guide me through it on here. It should make more sense like this.

What I'm after is to see if each day was higher or lower than the last with each row. Ideally this would be done using the arrow icons in conditional formatting and then I want to highlight the top and bottom 10% of values with red or green.

Is this possible?

The row labels have been erased due to privacy etc but I hope you get the picture.

Thanks,

Ok thanks, we're getting there! But is there anyway to have the up/down (green and red) icon arrows instead of the currently highlighted (filled red and green) cells. The technique is right which you've used but at the moment it looks like I've decorated my spreadsheet for christmas.

Ideally I want up/down arrow icons in all the cells that are currently highlighted and then to highlight and fill (as you've done) only the best performing (highest values) in the selection.

Is this possible?

Thanks,

also in you're latest version, not all of the highlighting is accurate as to whether the vale is higher or lower than the day before. Some vales have increased and are still highlighted red...

Ok is there anyway we can improve the accuracy I spoke of? I cant use it until it's completely accurate, maybe it's something to do with the formula...

Eg in column A they should be blank as they can't be compared to anything as it's the first set of data. Then in B4 the value is higher than that in A4 but is till highlighted red (indicating that the value has gone down). There are several other examples of this through the sheet.