Capture Higher High in numbers

[suresh kannah]

Hello

Want to capture how may higher high are there in numbers in G COl,
Details are mentioned in attachment.

Thanks in advance
Suresh

 

[Asheesh]

Suresh, how do you determine the benchmark to count the values..

 

[Hui]

Can you please explain the logic behind the Green Cells?

 

[suresh kannah]

Green cells will be based on conditional formatting based on higher high which i will do it .need the count of higher high of every row.

 

[Hui]

Firstly, the files don't have nay Conditional formats applied?

I understand the Count of the green cells
What I don't understand is why rows 2 & 4 have 2 cells highlighted, Rows 5 & 6 have 3 highlighted and row 3 only has one highlighted green

Please explain the logic for those colors

 

[Khalid NGO]

Hi Suresh,
You haven't mentioned the logic, but I think the benchmark is >26.

If so, you can use this for CF:
Select your range B2:E6
Go to conditional formatting > Formula:
=B2>26
Set desire format > hit ok.


for count in column G, try this in G2 and copy down:
=COUNTIF(B2:E2,">26")

Regards,

 

[suresh kannah]

Hello HUI

I have done conditional formating for the color now,The color is for higher high and mentioned in the attachment also

The G col has to only tell how many higher high are there,
For ex E2>D2 and D2>C2 So total in 2nd ROW is 2 that is D2 and E2 through conditonal formatiing we have got it green for higher highs


2) Or can we Get how many green are there in each ROW in G COL

 

[NARAYANK991]

Hi Suresh ,

See if this works :

=SUMPRODUCT(--($C2:$E2>$B2:$D2))

Copy this down.

Narayan

 

[suresh kannah]

Hello Team

Thanks for the solutions Mr.Narayan

Thanks
Suresh