Conditional Formatting

[kparadise]

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]
[/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[TD]H
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Name
[/TD]
[TD]Start
[/TD]
[TD]End
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Kyle
[/TD]
[TD]12/18/2017
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]Kyle
[/TD]
[TD]1/1/2018
[/TD]
[TD]1/16/2018
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Kyle
[/TD]
[TD]4/10/2018
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]Tony
[/TD]
[TD]3/1/2018
[/TD]
[TD]3/22/2018
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Tony
[/TD]
[TD]11/6/2017
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]Joyce
[/TD]
[TD]3/15/2018
[/TD]
[TD]4/12/2018
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Tony
[/TD]
[TD]11/8/2017
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Tony
[/TD]
[TD]3/1/2018
[/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Tony
[/TD]
[TD]3/5/2018
[/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Tony
[/TD]
[TD]3/26/2018
[/TD]
[/TR]
[TR]
[TD]8
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Joyce
[/TD]
[TD]3/15/2018
[/TD]
[/TR]
[TR]
[TD]9
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Joyce
[/TD]
[TD]3/30/2018
[/TD]
[/TR]
[TR]
[TD]10
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Joyce
[/TD]
[TD]11/8/2017
[/TD]
[/TR]
</tbody>[/TABLE]




Hello, looking to highlight certain cells based on 3 criteria. I have a list of Names and a Start and End dates. I also have a list of Names plus dates.

In the second list; I want to highlight all dates that fall in-between the start and end dates for each name. I cannot figure out the formula to use.

 

[Eric W]

Select column H and use this formula:

=AND(H1>=VLOOKUP(G1,$A$2:$C$10,2,0),H1<=VLOOKUP(G1,$A$2:$C$10,3,0))