Condtional formatting - other workbook VBA

Closed

caman - Jun 29, 2010 at 10:54 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jun 30, 2010 at 12:26 AM

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"
Microsoft websites are not opening ✓ - Internet & Social Networks Forum
How to right a blog? - Internet & Social Networks Forum
Publisher? ✓ - Office Software Forum
Top relaxing websites to relieve stress - Guide
Microsoft Publisher - Software Forum

1 response

Answer 1 / 1

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Jun 30, 2010 at 12:26 AM

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?

Problem connecting certain websites

Suggest me free plagiarism checker websites!

cannot publish on farmville

Publisher

Similar discussions

Subscribe To Our Newsletter!