+ Reply to Thread
Results 1 to 3 of 3

Apply CF After every 20 row

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

    Apply CF After every 20 row

    hi,
    i want to change background color after 20 rows using conditional formatting

    for example
    Range a10:a29 = red background color
    Range a30:a49 = blue background color
    Range a50:a69 = red background color
    Range a70:a89 = blue background color
    Range a90:a109 = red background color
    Range a110:a129 = blue background color and so on

    thanks in advance
    Use Code-Tags for showing your code :
    Please mark your question Solved if there has been offered a solution that works fine for you
    If You like solutions provided by anyone, feel free to add reputation using STAR *

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    23,805

    Re: Apply CF After every 20 row

    CF rules

    RED

    =AND(ROW()>=10,ISEVEN(INT((ROW()-10)/20)))

    BLUE

    =AND(ROW()>=10,ISODD(INT((ROW()-10)/20)))

    Applies to:

    =$10:$1000

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

    Re: Apply CF After every 20 row

    thank you very much

+ 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. [SOLVED] If date is within 1st 10 days of month, apply 1+x% percentage, otherwise apply 1+y%
    By losincog in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-28-2020, 12:38 PM
  2. [SOLVED] Apply VBA Script based on Text in one column and apply a formula in another column
    By vvincent in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-07-2016, 09:19 PM
  3. How to apply LEN in UDF?
    By itselflearn in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-29-2016, 05:41 PM
  4. How to apply VBA in every row
    By Evan. in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-30-2016, 08:37 PM
  5. [SOLVED] Apply Macro First UnprotectSheet After Apply Macro ProtectAgain Solved by : Sixthsense
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-02-2014, 05:32 AM
  6. How do i apply...
    By banny85 in forum Excel General
    Replies: 1
    Last Post: 06-22-2011, 12:30 PM
  7. anyone know how to apply for a job
    By Cheeky Charlie in forum The Water Cooler
    Replies: 6
    Last Post: 01-30-2009, 05:37 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