F
FS_Blues
hi, I'm new to this forum and to Excel in general...
I have this question... I'm a creating a spreadsheet to index certai
files in a folder. My question is in regards to the one column that
want to index the file sizes:
I want it to display "x.xx MB" (by default) or "x.xx GB" (if over 100
MB) automatically by just inputing a value in the cell (even tho 1 G
is 1024 MB - I think).
ex:
cell b1= 300 || display: 300.00 MB
cell b2=2300 || display: 2.30 GB
Now, I know could use this formula [- =if(b1<1000,b1&" MB",(b1/1000)&
GB") -] in a cell to display this and use a seperate cell just to stor
the value but I think that's inefficient... is there a better way to d
this?
I tried inputing the above formula to excel conditional formatting..
but it's not doing anything. I'm guessing Conditional Format onl
controls fonts, color, & BG color
Is the only way to get the above result by inputting some VBA code? I
so, how do I do so? I have not use VBA but I do have some _minor
programming experience here and there (C/C++, PERL, javascript and som
UNIX shells - still learning all of these).
General question... Is there book(s) you guys will recomend for VB
newbies like me? I like to use this not just for Excel but for othe
office programs as well (especially Access). BTW am I right to assum
that VBA is a somewhat specialized version of Visual Basic script fo
(only) office Applications? I'm assuming that's what it stands for.
Thanks in advance. Any input to any of the above is greatl
appreciated.
[/dumb newbie questions
I have this question... I'm a creating a spreadsheet to index certai
files in a folder. My question is in regards to the one column that
want to index the file sizes:
I want it to display "x.xx MB" (by default) or "x.xx GB" (if over 100
MB) automatically by just inputing a value in the cell (even tho 1 G
is 1024 MB - I think).
ex:
cell b1= 300 || display: 300.00 MB
cell b2=2300 || display: 2.30 GB
Now, I know could use this formula [- =if(b1<1000,b1&" MB",(b1/1000)&
GB") -] in a cell to display this and use a seperate cell just to stor
the value but I think that's inefficient... is there a better way to d
this?
I tried inputing the above formula to excel conditional formatting..
but it's not doing anything. I'm guessing Conditional Format onl
controls fonts, color, & BG color
Is the only way to get the above result by inputting some VBA code? I
so, how do I do so? I have not use VBA but I do have some _minor
programming experience here and there (C/C++, PERL, javascript and som
UNIX shells - still learning all of these).
General question... Is there book(s) you guys will recomend for VB
newbies like me? I like to use this not just for Excel but for othe
office programs as well (especially Access). BTW am I right to assum
that VBA is a somewhat specialized version of Visual Basic script fo
(only) office Applications? I'm assuming that's what it stands for.
Thanks in advance. Any input to any of the above is greatl
appreciated.
[/dumb newbie questions