Autofill formula and formating if data is entered in row

[allenayres83]

I have a formula set up in cell F11. Is there a way to automatically autofill a formula in F12 if data is entered into A12? I would like the cell formatting to autofill also because I like to highlight cells with formulas in them. Is this possible?

[mikeava]

Hi - can you attach a sample of your file?

[allenayres83]

I have attached a sample file. The blue cells are cells with formulas. I want these formulas and formatting to autofill down as I enter data in cell A2 , A3, ETC. I was wanting to accomplish this without VBA because I already have a worksheet change event to change the tab name. However, if that is the only way to accomplish this then I am willing to try it. Thanks

[mikeava]

Hi - silly question, sorry if I'm not understanding. But can't you just copy the formula down? It will put a value there once you enter a value in A based off the 1st part of your formula.

Or am I missing what you are trying to accomplish????

[allenayres83]

Hi - silly question, sorry if I'm not understanding. But can't you just copy the formula down? It will put a value there once you enter a value in A based off the 1st part of your formula.

Or am I missing what you are trying to accomplish????

You can and I did have it that way but I am making this for some not so computer savvy people and I am trying to limit how much they have to do in excel. I had it just auto filled to the bottom of the page but sometimes the data would roll over to the next page and the formulas would end. If I dragged it all the way to the bottom I would have to print way more pages than needed. Since the field is highlighted it wants to print everything highlighted whether there is data there or not. I guess I could leave it un-highlighted but my office has used highlighted cells as calculated fields for some time and everyone is used to that.

[mikeava]

So you can sit it up with Conditional Formatting if the cell is not blank then highlight it.

Highlight the values in Column F
Click on Conditional Formatting on the Data Tab
Click on Highlight Cell Rules
Click on More Rules
Click on Format only cells that contain
In middle of the box you will see Edit the Rule Description
Click drop-down box beneath Under Format only cells with
Select No Blanks
Click on Format
Click on Fill and select your color
Click OK and Apply

Then repeat for your other column