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