A lot of my job has to do with taking a text file separated by tabs into columns, and importing it into Excel 2010. Are there any codes I can embed in my text file which will format that cell? For example, when I import my text file, in some cases I want to make the cell background yellow, like a highlight.
Here's my idea with one example row:
Col1<tab>{bgcolor=yellow}Col2<tab>2000
Row2Col1<tab>Row2Col2<tab>2010
The {bgcolor=yellow} would highlight this row one, col 2, with a yellow background. But row 2, col 2, would have a default background color.
Thanks.
Here's my idea with one example row:
Col1<tab>{bgcolor=yellow}Col2<tab>2000
Row2Col1<tab>Row2Col2<tab>2010
The {bgcolor=yellow} would highlight this row one, col 2, with a yellow background. But row 2, col 2, would have a default background color.
Thanks.
