Conditional formating

[thewardn]

I am trying to make columns p-z turn green when contain the word "gap" and column aa contains "outed" only when both of theses match in the same line to change columns with gap to green.

 

[thewardn]

This is a image of kinda what im working with couldnt get it to attach to original post

 

[Peter_SSs]

Welcome to the MrExcel board!

I suggest that you investigate XL2BB for providing sample data to make it easier for helpers by not having to manually type out sample data to test with.
(If you have trouble with XL2BB, review the "XL2BB Icons greyed out" link in the 'Known XL2BB issues' section near the top of the XL2BB Instructions page linked above.)

Is this what you want?

25 01 21.xlsm
	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA
7													FULFILLED
8													FULFILLED
9													FULFILLED
10													FULFILLED
11													FULFILLED
12													FULFILLED
13	GAP	GAP											OUTED
14	GAP												FULFILLED
15													FULFILLED
16	GAP												FULFILLED
17													FULFILLED
CF

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
O7:Z17	Expression	=AND(O7="GAP",$AA7="OUTED")	text	NO