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,
JanetSounds like Conditional Formatting. Type quot;Highlight cells that meet specific
conditionsquot; into the Excel help to find out all about it.

quot;Janetquot; wrote:

gt; I was working with an old spreadsheet that a previous employee created. 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 other
gt; financial spreadsheets. After many hours at home trying to figure this out -
gt; I've not found an answer. How is this done?
gt; Thanks so much,
gt; Janet
gt;

Thankyou for your suggestion. Highlighting is a feature I am familiar with.
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 all the way down the column.

quot;Janetquot; wrote:

gt; I was working with an old spreadsheet that a previous employee created. 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 other
gt; financial spreadsheets. After many hours at home trying to figure this out -
gt; I've not found an answer. How is this done?
gt; Thanks so much,
gt; Janet
gt;

So does this sheet have conditional formatting?

quot;Janetquot; wrote:

gt; Thankyou for your suggestion. Highlighting is a feature I am familiar with.
gt; My request on the other hand relates to Fills/Shading that automatically
gt; appear within each individual cell after I type in my number or text amp; click
gt; enter. This happens all the way down the column.
gt;
gt; quot;Janetquot; wrote:
gt;
gt; gt; I was working with an old spreadsheet that a previous employee created. 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 other
gt; gt; financial spreadsheets. After many hours at home trying to figure this out -
gt; gt; I've not found an answer. How is this done?
gt; gt; Thanks so much,
gt; gt; Janet
gt; gt;

Hello Again:
I just figured it out.
It is by using Conditional Formatting.
Select Cell A4
Apply Simple Formula: =A4
Open Conditional Formatting
I applied the following to Condition 1:
Formula Is: =A4
Format: Select any Pattern/Color

Use Drag in order to apply this conditional fill formatting to subsequent
cells.

I really believe this is a great way to save those extra steps within large
worksheets.

Best Regards,
Janetquot;Janetquot; wrote:

gt; Thankyou for your suggestion. Highlighting is a feature I am familiar with.
gt; My request on the other hand relates to Fills/Shading that automatically
gt; appear within each individual cell after I type in my number or text amp; click
gt; enter. This happens all the way down the column.
gt;
gt; quot;Janetquot; wrote:
gt;
gt; gt; I was working with an old spreadsheet that a previous employee created. 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 other
gt; gt; financial spreadsheets. After many hours at home trying to figure this out -
gt; gt; I've not found an answer. How is this done?
gt; gt; Thanks so much,
gt; gt; Janet
gt; gt;