Google Sheets Conditional Formatting Question

We use Google Sheets to track appointments for a podcast.

I'd like to create a conditional formula that highlights a cell in red if the date of publication of a podcast episode is before the guest records the interview.

The sheet is divided into two areas.

The top of the sheet shows us when each episode airs and the name of the guest. The columns are as follows:

Guest Name: A2 to A106
Date for when the episode airs: B2 to B106

The bottom of the sheet is when we book the actual podcast interview. The columns are as follows:

Date of interview: A114 to A217
Name of guest: B114 to B217

The formatting would do the following:

1. For the name in cell A2 AND the date in cell B2 find the same name in cells B114 to B217
2. Compare the date in cell B2 with the date for the same name in A114 to A217
3. If the date in cell B2 is AFTER the date in cells A114 to A217 than nothing happens
4. If the date in cell B2 is BEFIRE the date in cells A114 to A217 than the cell turns red

Thanks for your help!

Scenario #1: Suppose the date of an episode airs on June 13th. If the guest records the episode on August 26th, the name of the guest next to June 13th is in red.

Scenario #2: Suppose the date of an episode airs on June 13th. If the guest records the episode on May 26th, no changes to the sheet.

A sheet contains podcast info in two parts:

• "Guest name" (Column A) and "Date Episode" (Column B) (A2:B106)
• "Recording date" and "Guest name" (A114:B217)

For each Guest name, the sheet must cross check the "Episode" and "Recording" dates, and highlight Guest name when the "Episode date" is prior to the "Recording date".

• Use Conditional Formatting for the Range A2:A106
• Use this Custom Formula

=if($B2<vlookup($A2,{$B$114:$B$217,$A$114:$A$217},2,0),true,false)

Notes:

• VLOOKUP uses an array for the "Range". This allows the column order to be switched.

Snapshot: Top of Sheet showing Conditional format

Snapshot: Bottom of Sheet