Trying to change font in a frozen cell based on the address of the active cell. Possible?

Hello all,

First let me thank all of you for being here and for your willingness to help out. The more comfortable I get using VBA, the more I find out I want to do with it. I am really starting to believe that Excel IS the Photoshop for data!

I have a workbook that extends to many many columns. In column A,B and C, I have employee information and those columns have been frozen to always be visible while working on the sheet. My question is, would it be possible to use VBA to enlarge the text or change the font of an employee's name (column B for example) when the active cell is on that employee's row? If the active cell is AA45, I would like to change the font of B45. If I arrow down to AA46, B45 goes back to default and B46 gets changed.

Up to this point, all of my VBA has been based on a value or a change in a selected cell. I was wondering if I could have these changes made without changing or adding a value to a cell.

I thank you all for pointing me in the right direction.

Scott