Need Code to look for blank rows and copy one cell to another

Hello,
I am looking to write a code that will look at a range (which can vary from A16:F2000) and
1)will find all blank rows,
2)increase the size of the row height in the blank rows to 30,
3)change the fill of the row to a color
4)copy the cell value from column F of the row below the blank into column C of the blank row.
5)Increase the font to 20pt, bold and center the word in the cell

so for all the blank rows take the value of the cell in the row below, column F and move it into the row above, column C. And format the row.

I am slowly chipping away at a bigger code and have been stuck on how to start this part. Any help would be great!

Try this:

Please Login or Register  to view this content.