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.

Condtional formatting - other workbook VBA
Vba case like - Guide
Number to words in excel without vba - Guide
Enable vba in excel - Guide
How to clear formatting in excel - Guide
Vba check if value is in array - Guide

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 to use conditional format based on text?

Highlight cell if another cell contains specific text

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

Publisher

Similar discussions

Subscribe To Our Newsletter!