Need VBA to do conditional formatting which affects font size of moving target

[TonyJBella]

Hello,

first time poster here

So I've got a workbook that I use for creating checklists. I have a column that has the title "Staging / Lighting" which can move anywhere in the range H3:H200. So the way it works is on another sheet of the workbook, I go through and click on different things in a long list that then populates this nicely formatted list on another sheet that can fit on one printed page. And as i'm clicking along, creating / deleting things that end up on the list, the "Staging / Lighting" title can move, anywhere from H3:H200. I need VBA that can make "Staging / Lighting" size 16 font no matter where it is in H3:H200 at any given time, and everything else in that range to remain at size 9 font. I've gotten VBA to change the font size to 16, but as soon as it moves from its spot, it's font size reverts back to 9. I need it to be size 16 no matter where it's moved to in that range and as it moves around, everything else stays at 9.

thanks for your help!

 

[TonyJBella]

Also, i'm running excel 2010. I really wish microsoft would allow you to change font size with the conditional formatting tool, but they do not, for some reason...