+ Reply to Thread
Results 1 to 6 of 6

Auto Fill formating down 1 row according condition

  1. #1
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,080

    Auto Fill formating down 1 row according condition

    hello
    i m using below code to fill down the formatting
    Please Login or Register  to view this content.
    i want some change in code ?

    i want when i enter a data in c4 then format fill down +1 row, = C5:P5
    when i enter a data in c5 then format fill down +1 row = C6:C6

    Please Login or Register  to view this content.

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Auto Fill formating down 1 row according condition

    Hi, haroon2015,

    if you donīt have any other code of the same name behind the worksheet you may try
    Please Login or Register  to view this content.
    You may need to add a restriction regarding from which row the code should work if needed.

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  3. #3
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,080

    Re: Auto Fill formating down 1 row according condition

    Hello HaHoBe

    i don't want to copy contents of Range ("C5:P5")

    i want only fill formatting................

  4. #4
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,080

    Re: Auto Fill formating down 1 row according condition

    only formating
    Please Login or Register  to view this content.

  5. #5
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Auto Fill formating down 1 row according condition

    Hi, haroon2015,

    Quote Originally Posted by opening post
    i m using below code to fill down the formatting
    What does that code do for you? Definitely not only fill down the formatting...

    Inserting the range would lead to that result as well:
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Ciao,
    Holger
    Last edited by HaHoBe; 04-27-2014 at 02:51 AM.

  6. #6
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,080

    Re: Auto Fill formating down 1 row according condition

    Thanx HaHoBe

    works perfect thanx

    +1 Repu will add later

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Condition formating
    By virencm in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-30-2014, 08:42 PM
  2. data auto fill base on condition.
    By johncena in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-20-2013, 04:30 PM
  3. Condition formating a cell in a worksheet based off formating of another cell
    By bdberger1985 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-07-2013, 05:52 PM
  4. Replies: 1
    Last Post: 09-07-2011, 05:57 PM
  5. Auto fill in text on condition format
    By choy96 in forum Excel General
    Replies: 4
    Last Post: 12-20-2010, 11:48 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1