Conditional Format to draw top and bottom borders at first and last of a group of text

I want to use conditional format to make box borders in my table. The condition is that if there is information in column C, then the format will put a top border and a bottom border in the table, but doing this puts lines across every row. I need a condition that says to do the top line across the whole table at the first row of information in column C, and the bottom line across the whole table at the last row of information in column C. I have conditionally formatted the side lines but can not manage to do the top and bottom lines. I have included 3 attachments: 1) My table so far with conditionally formatted side borders. 2) Manually draw in lines of what I want it to look like. 3) Conditional Format formulas that I have used so far. I have posted this question before but got no response, so I thought I would try to re-word it. Please Help, I'm only new to excel and new to posting.

Thank you hemesh for your reply. This has got me much closer to what i am try to achieve. Putting lines in the right place, but as I do not want the lines to be done on every row. Just the first and last row.maybe there is a formula to now hide the middle lines or duplicate lines. Further help from anyone would be appreciated.

I thank you very much FDibbins !!! This worked. I had spent so much time trying to work this out myself and trying to get online help and had no resolve. I probably could have drawn them in by hand but I am too stubborn for that and I knew there must be a formula. I just did not know how to do it. So once again THANK YOU. Your a gem.

thanks for doing the (SOLVED) for me, you bet me to it, the kids were grabbing at my ankles and I was dragged away. LOL