Excel Formula for if two separate columns contain certain data

[LyndaPM]

I have a very large spreadsheet over 25000 rows and want to highlight rows if Column D contains NONAMEPLATE and column X contains the number 2012 in it. Can't figure it out for the lifew of me.

 

[Cubist]

Try:

Book1 (version 2).xlsb
	D																				X
1	NONAMEPLATE																				Something 2012
2	NONAMEPLATE																				Something 2013
3	NONAMEPLATE																				Something 2014
4	NOT																				ED-2012-024
5	NONAMEPLATE																				ED-2012-024
Sheet5

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D1:X5	Expression	=($D1="NONAMEPLATE")*(ISNUMBER(SEARCH("2012",$X1)))	text	NO

 

[LyndaPM]

Try:

Book1 (version 2).xlsb
	D																				X
1	NONAMEPLATE																				Something 2012
2	NONAMEPLATE																				Something 2013
3	NONAMEPLATE																				Something 2014
4	NOT																				ED-2012-024
5	NONAMEPLATE																				ED-2012-024
Sheet5

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D1:X5	Expression	=($D1="NONAMEPLATE")*(ISNUMBER(SEARCH("2012",$X1)))	text	NO

Worked beautifully thank you so much

 

[Cubist]

You're welcome.