What type of formatting are you painting?

If Conditional Formatting you may have to look at absolute and relative
references in your rules.


Gord Dibben MS Excel MVP

On Wed, 24 Jun 2009 11:46:02 -0700, kris
wrote:

When I try applying format painter in another cells in excel 2007, formating
doesn't happen.

Please help.