Conditional formatting

[KClem]

In column E on sheet 'Reading', highlight any specific text that appears in column A on 'class information' sheet.

AND

Also if specific text in column B of 'class information' sheet is in column E underline text.

many thanks for any help

[daffodil11]

The sheets you describe do not appear anywhere on your attachment.

[KClem]

sorry wrong spreadsheet

[daffodil11]

Click E11, go to conditional formatting, select Formula.

First rule:
=ISNUMBER(MATCH(E11,'Class Information'!$A$2:$A$12,0))

Set highlight

Second Rule:
=ISNUMBER(MATCH(E11,'Class Information'!$B$2:$B$6,0))

Set underline

Set both: Applies to E11:E144

Do not check the boxes for Stop When True, so that effects are added cumulatively