I'm not entirely sure what you are looking for, but there is no built
in way to enumerate all of the various format options in effect for
all the cells in a worksheet. You might want to provide much more
detail about just what you need to determine.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional,
Excel, 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com



On Tue, 18 May 2010 08:42:01 -0700, Tahera <Tahera
@discussions.microsoft.com wrote:

I am marking learners assignments in excel. Want to know an easier way to
check all formatting techniques applied in the worksheet