I was working with an old spreadsheet that a previous employee created. When
I enter the new amounts & then tab down to the next cell, a fill applies
itself automatically. I like this feature & 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,
Janet

Sounds like Conditional Formatting. Type "Highlight cells that meet specific
conditions" into the Excel help to find out all about it.

"Janet" wrote:

I was working with an old spreadsheet that a previous employee created. When
I enter the new amounts & then tab down to the next cell, a fill applies
itself automatically. I like this feature & 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,
Janet

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 & click
enter. This happens all the way down the column.

"Janet" wrote:

I was working with an old spreadsheet that a previous employee created. When
I enter the new amounts & then tab down to the next cell, a fill applies
itself automatically. I like this feature & 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,
Janet

So does this sheet have conditional formatting?

"Janet" wrote:

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 & click
enter. This happens all the way down the column.

"Janet" wrote:

I was working with an old spreadsheet that a previous employee created. When
I enter the new amounts & then tab down to the next cell, a fill applies
itself automatically. I like this feature & 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,
Janet

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,
Janet


"Janet" wrote:

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 & click
enter. This happens all the way down the column.

"Janet" wrote:

I was working with an old spreadsheet that a previous employee created. When
I enter the new amounts & then tab down to the next cell, a fill applies
itself automatically. I like this feature & 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,
Janet