Conditional Formatting

Try

Conditional Formatting

• Highlight applicable range >> A2:H100
• Home Tab >> Styles >> Conditional Formatting
• New Rule >> Use a formula to determine which cells to format
• Edit the Rule Description: Format values where this formula is true: =A2=$A$1
• Format… [Number, Font, Border, Fill]
• OK >> OK

Jeff and TMS, PLEASE FIND MY WORKBOOK IN ATTACHMENTS

Sorry guys but this doesn't work

I need excel to do the following

When I type RUS into search box 1, I need excel to highight all the RUS in the subject table

Any ideas?

Thank you both

MHartle