IF statement that compares first two characters to a FAIL list, and displays PASS or FAIL

[IamJAMES]

[FONT=&quot]I need help building a function that....[/FONT]
[FONT=&quot]If the number starts with: 06, 10, 63, 71, 91 That row FAILS![/FONT]
[FONT=&quot]Example: (Wont let me upload photo)[/FONT]
[FONT=&quot]​[/FONT]
[TABLE="class: s570a4-19 MzlEq"]
<thead style="margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline;">[TR="class: s570a4-20 bKSoXW, bgcolor: rgba(255, 255, 255, 0.8)"]
[TH="class: s570a4-25 eCDbZz, align: center"]NUMBERS:[/TH]
[TH="class: s570a4-25 eCDbZz, align: center"]First Two Characters:[/TH]
[TH="class: s570a4-25 eCDbZz, align: center"]PASS/FAIL:[/TH]
[/TR]
</thead><tbody style="margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline;">[TR="class: s570a4-20 bKSoXW, bgcolor: rgba(255, 255, 255, 0.8)"]
[TD="class: s570a4-21 fyFZeq"]06239808723[/TD]
[TD="class: s570a4-21 fyFZeq"]06[/TD]
[TD="class: s570a4-21 fyFZeq"]FAIL[/TD]
[/TR]
[TR="class: s570a4-20 bKSoXW, bgcolor: rgba(255, 255, 255, 0.8)"]
[TD="class: s570a4-21 fyFZeq"]21328947982[/TD]
[TD="class: s570a4-21 fyFZeq"]21[/TD]
[TD="class: s570a4-21 fyFZeq"]PASS[/TD]
[/TR]
[TR="class: s570a4-20 bKSoXW, bgcolor: rgba(255, 255, 255, 0.8)"]
[TD="class: s570a4-21 fyFZeq"]10298472498[/TD]
[TD="class: s570a4-21 fyFZeq"]10[/TD]
[TD="class: s570a4-21 fyFZeq"]FAIL[/TD]
[/TR]
[TR="class: s570a4-20 bKSoXW, bgcolor: rgba(255, 255, 255, 0.8)"]
[TD="class: s570a4-21 fyFZeq"]29879229298[/TD]
[TD="class: s570a4-21 fyFZeq"]29[/TD]
[TD="class: s570a4-21 fyFZeq"]PASS[/TD]
[/TR]
[TR="class: s570a4-20 bKSoXW, bgcolor: rgba(255, 255, 255, 0.8)"]
[TD="class: s570a4-21 fyFZeq"]63839743993[/TD]
[TD="class: s570a4-21 fyFZeq"]63[/TD]
[TD="class: s570a4-21 fyFZeq"]FAIL[/TD]
[/TR]
[TR="class: s570a4-20 bKSoXW, bgcolor: rgba(255, 255, 255, 0.8)"]
[TD="class: s570a4-21 fyFZeq"]29874982749[/TD]
[TD="class: s570a4-21 fyFZeq"]29[/TD]
[TD="class: s570a4-21 fyFZeq"]PASS[/TD]
[/TR]
</tbody>[/TABLE]
[FONT=&quot]​[/FONT]
[FONT=&quot]​I used this function to find the first to characters:=LEFT(A2,2)[/FONT]
[FONT=&quot]​[/FONT]
[FONT=&quot]I tried this function, to display pass or fail, but didn't work:[/FONT]
[FONT=&quot]=IF(AND(B2="06", B2="10", B2="63", B2="71", B2="91"), "PASS", "FAIL")[/FONT]
[FONT=&quot]Admittingly, I am a notice at functions, but need help with this issue.[/FONT]
[FONT=&quot]​[/FONT]
[FONT=&quot]​[/FONT]
[FONT=&quot]​[/FONT]
[FONT=&quot]BONUS POINTS IF THERE IS A FUNCTION THAT TURNS PASS GREEN, AND FAIL RED!!!!!
EVEN MORE BONUS POINTS IF YOU CAN DO IT IN TWO COLUMNS, ONE FOR NUMBERS AND ONE FOR PASS AND FAIL WITHOUT DISPLAYING FIRST TO CHARACTERS.[/FONT]

 

[Peter_SSs]

Welcome to the MrExcel board!

Formula in B2 is copied down.
Then select B2 down to the end and apply the Conditional Formatting rules shown. If you need detailed steps for this, post back.

Excel Workbook
	A	B
1	NUMBERS:	PASS/FAIL:
2	06239808723	FAIL
3	21328947982	PASS
4	10298472498	FAIL
5	29879229298	PASS
6	63839743993	FAIL
7	29874982749	PASS
Pass fail

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2	1. / Formula is =B2="PASS"	Abc
B2	2. / Formula is =B2="FAIL"	Abc