CF Formula

[AussieVic]

Hi, i am after a conditional formating formula that will match securities in Sheets Workings to RawData, if found then highlight cell pattern red.

Data in Workings will be horizontal, there is no fixed range

Excel Workbook
	A
1	Security
2	WTIEF
3	WCAF
4	VBNGHJ
5	WCBALF
6	WTAEF
Raw

Excel Workbook
	A	B	C	D	E
1	Security	Security	Security	Security	Security
2	WTIEF	WCAF
3	TRGFGH
4	VBNGHJ
5	WCBALF	WTAEF	NHJUILO
Workings

 

[AussieVic]

*bump*

 

[AussieVic]

*bump*

 

[AussieVic]

*bump*

 

[AussieVic]

*bump*

 

[AussieVic]

*bump*

 

[AussieVic]

*bump*

 

[Matty]

Try this...

Name A2:A6 in Raw with an appropriate name. I have used SECURITY.

Now, use the following Conditional Formatting formula across A2:E5 in Workings:

=ISNUMBER(MATCH(A2,SECURITY,0))

And format as desired...

Matty