Condtional formatting - other workbook VBA

[Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
How can i use conditional formatting to extract data from other workbook?
i tried,
=IF(LEFT(B26,3)="SSS",VLOOKUP(B26,'XXX.xls!$A$4:$E$119,4,FALSE))

but the error message " You may not link to other workbook via conditional formatting" showed up.
what can i do with this situation? People out there mentioned "define name" but im not sure how can it be done?
Thanks.

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
801
you can try to write a macro if you are familiar with vba