Formula for highlighting number that decrease cell by cell and percentage difference of each cell

[excelrater]

This is a little hard to explain but I have two things i would like to achieveI am an extreme newbie so any help even written formulas for me to try would be wonderful

1. What I would like to achieve is starting from cell A2 and working to the right of the cell---> to the next cell B2 if the number is higher in A2 then B2 I want it A2 Highlighted by it being highlighted(A2) it means it is larger then B2. Then go on to the next cell B2 and compare it to the cell on the right C2 if B2 is Higher then C2 then I would like B2 highlighted. And the formula going all the way to J2. so A2 see if it is higher then B2 if it is A2 will be highlighted, then the same for B2 see if it is higher then C2 if it is B2 will be highlighted,then the same for C2 see if it is higher then D2 if it is C2 will be highlighted, then the same for D2 see if it is higher then E2 if it is D2 will be highlighted ALL THE WAY TILL J2. I only want the number that is higher to the next cell to be highlighted starting from left to right.

2.and if possible to show the percentage difference of how much more is A2 higher Then B2 etc.....

I will upload a blank sheet and a sheet where i would like the formula to highlight

any help will be much appreciated.
A2 B2 C2 D2 E2 F2 G2 H2 I2 J2

1. 1089521 876191 572320 362712 171594 58012 59249 43508 109115 142496 2. 1366944 308696 92939 202550 600641 180249 85376 935 0 -5000 3.15995969 7151714 4205283 -719504 3082535 -620273 2055152 225922 64325 -273826 4. -257062 -707224 -109865 -138332 -140853 -52331 -76367 -38930 -2988 -26591 5. 0 0 0 0 0 0 0 0 0 0 6. 0 0 0 0 0 0 0 0 0 0 7.-1594985 -1519345 -887009 -926182 -527912 -238779 -234317 -199310 -2988 -26591 8. 0 -152060 -137265 -851788 305106 13380 -11750 -5000 -22276 19461 <tbody> </tbody>

<tbody>
</tbody>

 

[excelrater]

Re: Hello Need Help formula for highligting number that decrease cell by cell and percentage difference of each cell

I made an error 7 b2 should not be highlighted

 

[lrobbo314]

Re: Hello Need Help formula for highligting number that decrease cell by cell and percentage difference of each cell

Select your data range and create the following conditional format.

=AND(A2>B2,B2<>"")

Then set the conditional format to be green text.

 

[excelrater]

Re: Hello Need Help formula for highligting number that decrease cell by cell and percentage difference of each cell

THANK YOU FOR HELPING ME I AM SUCH A NEWBIE CAN YOU PLEASE EXPLAIN IN DETAIL WHAT TO DO AND IF YOU CAN WRITE THE FORMULA IN FULL FOR ME I WOULD APPRECIATE THAT SO MUCH I AM VERY VERY NEW TO FORMULA IMPLEMENTATION. soory about the caps

 

[excelrater]

Re: Hello Need Help formula for highligting number that decrease cell by cell and percentage difference of each cell

if you can please write the formula from A2 all the way to J2 much much appreciated.

 

[lrobbo314]

Re: Hello Need Help formula for highligting number that decrease cell by cell and percentage difference of each cell

You're not putting the formula into any of the cells themselves. Select the cells that have your data. Go to the ribbon and click 'Conditional Formatting' and select 'New Rule'. This will bring up a dialog box. There, select 'Use formula to determine which cells to format'. Then paste the formula from my previous post. There will be a 'Format' button where you can choose how you want to format the cells.

 

[excelrater]

Re: Hello Need Help formula for highligting number that decrease cell by cell and percentage difference of each cell

thank you i did eactly what you said(Go to the ribbon and click 'Conditional Formatting' and select 'New Rule'. This will bring up a dialog box. There, select 'Use formula to determine which cells to format'.) I used this as the formula this =AND(B2>C2,C2>D2,D2>E2,E2>F2,F2>H2,H2>I2,I2>J2) but it highlights some correctly and some incorrectly is the formula wrong that I wrote?

and thank you so much for taking the time to help me much much appreciated.

 

[lrobbo314]

Re: Hello Need Help formula for highligting number that decrease cell by cell and percentage difference of each cell

just paste
=AND(A2>B2,B2<>"")

 

[lrobbo314]

Re: Hello Need Help formula for highligting number that decrease cell by cell and percentage difference of each cell

The formula is using relative cell references, so you don't have to manually type in the rest. e.g. C2>D2,D2>E2,E2>F2,F2>H2,H2>I2,I2>J2

 

[excelrater]

Re: Hello Need Help formula for highligting number that decrease cell by cell and percentage difference of each cell

AHH OK SO JUST SELECT ALL THE CELLS I WANT THEN AND PASTE YOUR FOMULA? sorry about caps ok let me try again then.