VBA Code to find and apply formatting to specific text strings

Hi all,

I am very new to the Macro and VBA "underworld" of Excel, and I have a (hopefully) simple procedural formatting task that I believe can be automated; I'm just not sure how.

The short way to explain what I need done is to refer you to the attached worksheet and say that I would like to write code to have excel apply formatting to the "raw" worksheet and make it look like the "formatted" worksheet.

The long way is to provide a detailed explanation of the 3 specific subgoals to this general formatting task:

1a) Find all cells containing the trial name (e.g., "Trial 2 Interruption nil") and 1b) Highlight all cells on the same row yellow

2a) Find all cells signaling the beginning of an interruption (e.g., "Interruption TQ begins"),
2b) Find all cells signaling the end of an interruption (e.g., "Interruption ends"), and
2c) Highlight all cells on the same rows as 2a and 2b and all cells on rows in between 2a and 2b light yellow

3a) Find all cells in column F containing the word "incorrect" and
3b) Highlight those cells red

The purpose of this reformatting task is to make a range of datasets more amenable to coding and analysis. Any help would be greatly appreciated.