Automatically apply a fill when entering text

J

Janet

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
 
B

bigwheel

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

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.
 
B

bigwheel

So does this sheet have conditional formatting?

Janet said:
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.
Click to expand...
 
J

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
 
Top