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