Condtional formatting - other workbook VBA

Closed

caman - 29 Jun 2010 à 22:54
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 30 Jun 2010 à 00:26

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.

"Publish your article in rss format for other websites to syndicate"
Publish an article on LinkedIn: company page, in app - Guide
Top relaxing websites to relieve stress - Guide
Best image format: for web, for printing, for quality - Guide
Copying a Conditional Format to other cells... - Excel Forum
Can ping but can't browse ✓ - Internet & Social Networks Forum

1 response

Réponse 1 / 1

venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
30 Jun 2010 à 00:26

you can try to write a macro if you are familiar with vba

Similar discussions

How can I publish a study that I have done on this website?

Publisher?

Publisher

I am Facing Problem in My Redirected Blog site Rss feed

Similar discussions

Subscribe To Our Newsletter!