macro that will change the font of a cell if i change a value

[jk]

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?

 

[Wigi]

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).

 

[Gord Dibben]

Do you need it to be a macro?

Conditional Formatting would work as well.


Gord Dibben MS Excel MVP