Well.., the logic on Sheet2 escapes me because Name4 has an "H" in
Q3 but is not formatted.

The other names have the criteria in more than 1 Q, but no
formatting other than the last Q containing criteria.

In order to code this the criteria needs 'structured' logic!


Only the Q's are brought to sheet 2 and only if they have an Y an N
or R

TYPO TYPO sorry.

Howard

Okay, that helps!
Whats the logic for the formatting? (color, boldface)

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion