Help conditional formatting every next cell of column

hi guys i am new here and i really need help i cant explain so i just made an illustration to illustrate what i wanted to do

CIPhnhf.jpg

what i want to do is detect every next number and see if its high and low then count

thank you in advance

If you want it all in one formula, that's a little more complicated than im willing to attempt right now. However, if you can do it in steps (helper columns), it isn't that bad.

=countif(A2:A21,"<50") would count your lower values.

=mod(row(a2),2) in C then double click down gives a helper column telling if they are odd or even (every other row).

so then you can use:

=countifs(A2:A21,"<50",C2:C21,1)

to determine if low and if it is on every other row as desired.

if you want it to print out results on the side as you have, you could approach it a different way.

=if(mod(row(a2),2)=1,if(a2>=50,"higher","lower"),"") in the B column

then you could use

=countif(b2:b21,higher)

and


=countif(b2:b21,lower)

wow thats fast thank ill try this right now :D

hi i was trying to play with the example code you given to do another task but i cant seem to figure it out how i almost played with it for 2 hours pls refer to screenshot

bWK6BWy.jpg

what i was trying to do here is that detect numbers from 90 above and tell if the value next to it is higher or lower

thanks

Write this formula on B2 and copy down :

Please Login or Register  to view this content.

sorry i think i now know what i want to do actually i am sorry if i am being spoonfed but glad to find out that there is an active community dedicated to help but still im new to excel so pls bear with me and help me accomplish what i need ..

pls see screenshots

oP34MYq.jpg
T5JziYx.jpg
MiylTe1.jpg
6CqP4MW.jpg

i am having hard time to explain thats why i chose to make screenshots instead to explain what i want to accomplish on the screenshots i want to find certain numbers and detect whether the value next to it is high or low, i made 4 separate screenshots just to make it look simple cause i dont want to have a lot of arrows :P but its supposed to be in 1 page

This formula will give you that result :

Please Login or Register  to view this content.

This will count the higher value from row 2 to 21. Change it as you want. If your starting row is 3 then change A1 to A2 and A2 to A3. If your ending row is 50 then change 21 to 50 and 22 to 51.

If you want to show the words "Higher" and "Lower" beside then write this formula in B2 and copy down.

Please Login or Register  to view this content.

Originally Posted by sanram

This formula will give you that result :

Please Login or Register  to view this content.

This will count the higher value from row 2 to 21. Change it as you want. If your starting row is 3 then change A1 to A2 and A2 to A3. If your ending row is 50 then change 21 to 50 and 22 to 51.

what if i want the whole column? can i just do it? as A:A?

No. This formula will not work with whole column.

This will not be a good choice to use that formula on whole column. But I providing it as you want :

Please Login or Register  to view this content.

ok thanks i got over 3000 numbers and have to verify if its working correctly but really i appreciate your time and effort :D

You are welcome and thanks for the rep.

if i can only donate i would anyway is it possible to just get the value to be compared on a cell? example

vbrSNg9.jpg

so i just have to drag it rather than type the numbers over and over again

Yes. But you have to use this in this way :

Please Login or Register  to view this content.

Here C8 is lower value, C9 is Upper value and C10 is 50.

thank you guys closing this thread now as i have another question :D