Hello MrExcel community 
I am searching for a solution to resize all of the rows in a worksheet based on the calculated value in column H. I have used column H a conditional formatting helper. In this case, the only two values in column H are "None" and "Color". These values are being returned from an if statement that I wrote. Anyway, I have conditionally formatted the sheet to color fill all rows containing "Color" in column H but I also want to resize these to basically create a thick border as conditional formatting only has thin boarders.
If someone could help me write a sub procedure to find all rows with "Color" in column H and resize them I would be extremely grateful as I have not found an easy solution at the moment. Also, as I add more data, the amount of "Color" and "None" values will change as well.
Thank you!

I am searching for a solution to resize all of the rows in a worksheet based on the calculated value in column H. I have used column H a conditional formatting helper. In this case, the only two values in column H are "None" and "Color". These values are being returned from an if statement that I wrote. Anyway, I have conditionally formatted the sheet to color fill all rows containing "Color" in column H but I also want to resize these to basically create a thick border as conditional formatting only has thin boarders.
If someone could help me write a sub procedure to find all rows with "Color" in column H and resize them I would be extremely grateful as I have not found an easy solution at the moment. Also, as I add more data, the amount of "Color" and "None" values will change as well.
Thank you!