• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Copying formulas/data validation/conditional formatting

C

charlesbaxter

New Member
Dear all,


I have table with a number of formulas/data validation techniques and conditional formatting rules in the first row.


Row 3 has all the formulae I want in but as the table has a new row added to it for each new entry (new row becomes row 3), I would like the formulae and the conditional formatting to be added to the row on creation.


At the moment I am dragging the formulae up from the row below to the new row inserted but I wonder if there is an automatic way.


Any help would be appreciated.


Thanks
 
If your data is in a table & if u insert a row, the above formulas & the conditional formatting will be automatically copied to the newly inserted row.


Are you referring to a column instead of you, pls clarify.
 
My data was not in a table which may explain my problem.


How do I make it into a "table" for auto-populating - the only tables I create are by putting bold gridlines around my work - amateur I know.


Thanks
 
You must log in or register to reply here.
Back
Top