+ Reply to Thread
Results 1 to 2 of 2

conditional formatting alternating rows

  1. #1
    Forum Contributor
    Join Date
    08-27-2019
    Location
    europa
    MS-Off Ver
    excel 2007
    Posts
    456

    conditional formatting alternating rows

    In the attached sheet there is a function in name manager = FormulaA
    linked to conditional formatting
    =IF(FormulaA;MOD(1+ROW();2);0)
    to color the alternating rows.
    Unfortunately, this function "covers up" the other formats that are no longer displayed
    You can edit?
    I hope I have explained
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    08-27-2019
    Location
    europa
    MS-Off Ver
    excel 2007
    Posts
    456

    Re: conditional formatting alternating rows

    As an alternative to formatting I found this macro that colors the lines:
    Please Login or Register  to view this content.
    you can change it to make it work:
    from row 6 from column A to column Q
    Thanks you
    xam

+ 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. Replies: 3
    Last Post: 07-01-2020, 10:15 AM
  2. Formatting alternating blocks of rows
    By ngbc in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-12-2018, 08:26 AM
  3. formatting rows with alternating colors
    By seemore in forum Excel General
    Replies: 2
    Last Post: 10-17-2014, 03:20 PM
  4. Replies: 1
    Last Post: 02-15-2013, 09:41 PM
  5. [SOLVED] Colour conditional formatting alternating blocks of rows
    By Deanomcbeano in forum Excel General
    Replies: 7
    Last Post: 10-03-2012, 01:48 PM
  6. Conditional formatting similar to shading alternating rows
    By Conan Kelly in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 08-22-2006, 06:20 PM
  7. how do I use conditional formatting for alternating cell shading?
    By Exceluser in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-12-2006, 12:30 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