More Excel Madness..
Ok, first the easy one – alternate row colors ? simple :
You can create a worksheet with alternating coloured rows (striped) with conditional formatting.
First, select the range that you want striped (or the whole sheet).
Next, go to Format/Conditional formatting. In the dropdown where it say value is, select “formula is”
In the textbox on the right type the expression “= mod(row(),2)=0″ (without the quotes, of course.
i got this from http://www.utteraccess.com/forums/showflat.php?&Number=1177188
Next the hard part.
I want to reference a set of cells dynamically in another spreadsheet (basically a CSV file) so i want to be able to tell my workbook the name of the file and then which columns i want.
It can be done! rather than try to explain step by step, here is the workbook!:)
I couldnt get it to reference files which werent already open in Excel, however, it remembers the data if you close the referenced file. for my app i dont care about having to open them both.
will try to work it out sometime…
Subscribe