| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic Fills Applied To Cells After Entering a Number
Awesome! Thank you so very much.
Janet "Otto Moehrbach" wrote: 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 "Cell Value Is". In the next block select "between". 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 "Pattern" 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 "Janet" wrote in message ... 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number of cells that have same values | Excel Discussion (Misc queries) | |||
| how to format only a specific character or number in each cell withina range of cells | Excel Worksheet Functions | |||
| Count the number of Cells in one ROW with conditions | Excel Worksheet Functions | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
| Count number of shaded cells | Excel Discussion (Misc queries) | |||
Threaded Mode
