1

Topic: Import from Excel

Colleagues, prompt
Is available  a file (the way is known) it is necessary to import only that data in which values of cells of a column have color of a font red (who invented criterion-color?)

2

Re: Import from Excel

sdku;
Probably, so - to open a file  both methods and functions  libraries to add an additional column in which to write down color number of cells of an interesting column, a file to save, well, and further you know what to do...

3

Re: Import from Excel

If red color - result of conditional formatting,
To use this condition as a selection condition.

4

Re: Import from Excel

sdku;
In Excel can add a column with the values corresponding to color?