i have a spreadsheet with conditional formatting and formulas in 2 o
the columns. the formula is based on 2 adjacent columns which ar
sometimes blank (but WILL be filled in at a later date). The proble
is when inserting a new row, it isnt copying the formula in these
columns into the new row, yet it IS copying the conditiona
formatting.

Why would it not copy the formula when the same formula is in ever
single row above it (even if the formula results in a blank cell value
the formula itself is still in every cell). also strange it copies th
conditional formatting, you would think if its going to copy it then i
would copy the formatting AND the formula, or neither.

anyway the person inputting the data doesnt know very much so i nee
the formulas to be automatically put into the new row when its inserte
(like it should be anyway).

under tools/options/edit i have ticked 'extend list formats an
formulas' so it should be copying it right? i insert a new row in th
middle of 10 other rows which are all filled in and all contain th
formula, and it leaves the cell completely blank

--
Message posted from http://www.ExcelForum.com