Does someone know how to create a macro that waits for changes in any cell
and when this occurs change the font of that cell?

That's possible.

For instance, copy-paste this code in the private module of the sheet where
you want to apply it:


Private Sub Worksheet_Change(ByVal Target As Range)

Target.Cells.Font.Name = "..."

End Sub


Fill in the desired font name and you can of course use other properties of
the target range as well. (bold, font size, alignment, and many others).

--
Wigi:
http://www.wimgielis.be = Excel/VBA, soccer and music


"jk" wrote:

Does someone know how to create a macro that waits for changes in any cell
and when this occurs change the font of that cell?

Do you need it to be a macro?

Conditional Formatting would work as well.


Gord Dibben MS Excel MVP

On Sun, 27 Jul 2008 14:38:35 -0700, jk wrote:

Does someone know how to create a macro that waits for changes in any cell
and when this occurs change the font of that cell?