Putting identifier when number of rows equals 37

Hi Guys,

Maybe somebody is going to help me with the following problem:
I was hoping in the worksheet attached:
Column J or K. can have a formula that can Identify if -> Colum H total is not equal to 37; and if Colum H total is 37 to place an identifier on each of the rows. These are actually small tables within one tablee, with number of rows summed up for each small table. I want to have highlighted those rows that add up to 37 in each small table. I hope you got my point
Many thanks in advance for your ideas and suggestions!

screenshots of the worksheet attached

Attachment 667186Attachment 667188

Simon

It mean that up to 35 you want red & above 35 green.
If yes then you apply conditional formatting.

when clicking on your attachment it returns an "invalid attachment" alert. If you want to upload an attachment please follow the instructions in the yellow banner at the top of the post.
AND, to clarify, it sounds like you are just looking for conditional formatting if the cell in column H has 37 in it, is that correct?
If so, then simply go to conditional formatting and new rule, format only cells that contain >> cell value >> equal to and put 37 in and select your format.
If not, then please clarify, possibly with examples in your uploaded workbook.

Hello simon86 and Welcome to Excel Forum.
Try pasting the following into cell J2 and then double click to copy down:

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.