Nick

Not sure what you're after but have you tried autofiltering to show just the
records to print?

Or have you tried using Word for printing and Excel as the source?

You could then use a query to pull the records to print as labels or in a
mailmerge.

I suppose you could use Conditional formatting to color the text white if
the records do not meet some type of criteria.

Maybe post a sample of some data and which you would want printed.


Gord Dibben MS Excel MVP

On Sun, 5 Oct 2008 10:59:02 -0700, Nick Phillips
wrote:

I need to be able to set a a worksheet up that will display and then print
student records, like you would in a mail merge, but using conditional
formatting in excel. Or is there a way of using conditional formatting in
word