a macro to format a row height and font, dependant upon a cell content

Dear guru's, I'm not one of them, but trying to learn....

I have a sheet with multiple rows, any row with a digit of >0 in a specific cell needs to have it's font size increased and row height to enable fit.

It cannot be done through conditional formatting (I'm using Excel 2007), but reckon a macro to look at each row in turn might do the trick.

Advice and guidance most welcome.

Thanks in anticipation - Peter F.