software

I was working with an old spreadsheet that a previous employee created. When
I enter the new amounts amp; then tab down to the next cell, a fill applies
itself automatically. I like this feature amp; would like to apply it to other
financial spreadsheets. After many hours at home trying to figure this out -
I've not found an answer. How is this done?
Thanks so much,
JanetAre you talking about autocomplete?

toolsgt;optionsgt;edit and check enable autocomplete for cell values

or do you mean

toolsgt;optionsgt;edit and extend data range formats and formulas

?

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon

quot;Janetquot; gt; wrote in message
...
gt;I was working with an old spreadsheet that a previous employee created.
gt;When
gt; I enter the new amounts amp; then tab down to the next cell, a fill applies
gt; itself automatically. I like this feature amp; would like to apply it to
gt; other
gt; financial spreadsheets. After many hours at home trying to figure this
gt; out -
gt; I've not found an answer. How is this done?
gt; Thanks so much,
gt; Janet
gt;Thankyou for your suggestion. Both features are enabled.
My request on the other hand relates to Fills/Shading that automatically
appear within each individual cell after I type in my number or text amp; click
enter. This happens automatically all the way down this particular column.
It seems as though it may be unusal - but I know several people who could
use this.
Do you have any further suggestions?
Thanks.

quot;Peo Sjoblomquot; wrote:

gt; Are you talking about autocomplete?
gt;
gt; toolsgt;optionsgt;edit and check enable autocomplete for cell values
gt;
gt; or do you mean
gt;
gt; toolsgt;optionsgt;edit and extend data range formats and formulas
gt;
gt; ?
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; Northwest Excel Solutions
gt;
gt; Portland, Oregon
gt;
gt;
gt;
gt;
gt; quot;Janetquot; gt; wrote in message
gt; ...
gt; gt;I was working with an old spreadsheet that a previous employee created.
gt; gt;When
gt; gt; I enter the new amounts amp; then tab down to the next cell, a fill applies
gt; gt; itself automatically. I like this feature amp; would like to apply it to
gt; gt; other
gt; gt; financial spreadsheets. After many hours at home trying to figure this
gt; gt; out -
gt; gt; I've not found an answer. How is this done?
gt; gt; Thanks so much,
gt; gt; Janet
gt; gt;
gt;
gt;

Janet
You can do this with Conditional Formatting. If you know you will be
entering nothing but numbers in these cells and you know that the numbers
will not be greater than, say 1000000, and not less than, say .01, do the
following:
Select all the cells that you want to act this way.
Click on Format - Conditional Formatting.
In the first block, select quot;Cell Value Isquot;.
In the next block select quot;betweenquot;.
In the next block type .01
In the last block type 1000000 (or any number you will not exceed)
Click on the Format button (in the conditional formatting dialog box)
Select the quot;Patternquot; tab
Click on the color you want
Click OK
Click OK
Done

You can also do this with VBA. Post back if you need more. HTH Otto
quot;Janetquot; gt; wrote in message
...
gt;I was working with an old spreadsheet that a previous employee created.
gt;When
gt; I enter the new amounts amp; then tab down to the next cell, a fill applies
gt; itself automatically. I like this feature amp; would like to apply it to
gt; other
gt; financial spreadsheets. After many hours at home trying to figure this
gt; out -
gt; I've not found an answer. How is this done?
gt; Thanks so much,
gt; Janet
gt;
Awesome! Thank you so very much.
Janet

quot;Otto Moehrbachquot; wrote:

gt; Janet
gt; You can do this with Conditional Formatting. If you know you will be
gt; entering nothing but numbers in these cells and you know that the numbers
gt; will not be greater than, say 1000000, and not less than, say .01, do the
gt; following:
gt; Select all the cells that you want to act this way.
gt; Click on Format - Conditional Formatting.
gt; In the first block, select quot;Cell Value Isquot;.
gt; In the next block select quot;betweenquot;.
gt; In the next block type .01
gt; In the last block type 1000000 (or any number you will not exceed)
gt; Click on the Format button (in the conditional formatting dialog box)
gt; Select the quot;Patternquot; tab
gt; Click on the color you want
gt; Click OK
gt; Click OK
gt; Done
gt;
gt; You can also do this with VBA. Post back if you need more. HTH Otto
gt; quot;Janetquot; gt; wrote in message
gt; ...
gt; gt;I was working with an old spreadsheet that a previous employee created.
gt; gt;When
gt; gt; I enter the new amounts amp; then tab down to the next cell, a fill applies
gt; gt; itself automatically. I like this feature amp; would like to apply it to
gt; gt; other
gt; gt; financial spreadsheets. After many hours at home trying to figure this
gt; gt; out -
gt; gt; I've not found an answer. How is this done?
gt; gt; Thanks so much,
gt; gt; Janet
gt; gt;
gt;
gt;
gt;