How to have conditional format highlight cell based on two cell values?

[AccountingJ]

Hi everyone

I have a workbook that I would like for the cell to be red if the month found in range A22:A24 equals any of the months found in range A8:A19 and they equal to "Fail" which is in column "D".

Please Login or Register  to view this content.

but it's not working.

[CRIMEDOG]

use
=And(Countif($A$8:$A$19,$B22)>0,$D8="Fail")

[AccountingJ]

It's close, I changed the $b22 to $a22 and it marks red except, it marks June instead of May.

[CRIMEDOG]

=VLookup($A22,$A$8:$D$19,4,False)="Fail"

[AccountingJ]

Thank you CrimeDog, that did it.