Hide row in excel and maintain table format

[p ol]

I'm hidding a row using VBA when a cell is selected. The problem is that when I hide the row the colors of the table format mess up. Any way to keep the table format updated when hidding a row? Thanks in advance

You can see an example in the pictures, table colors mess up when I hide Row 45.

EDIT:This is my code... when I click cell C44 it changes from red to green or backwards, and hide or unhide row 45.

Please Login or Register  to view this content.

1.jpg

When I hide row 45 the rest of the table turns blue...

2.jpg