+ Reply to Thread
Results 1 to 5 of 5

cell colours for every 15th cell with data (condition formatting and Macro)

  1. 01-09-2012, 04:47 AM #1
    eastydie
    eastydie is offline
    Registered User
    Join Date
    06-11-2010
    Location
    Manila
    MS-Off Ver
    Excel 2007
    Posts
    29

    cell colours for every 15th cell with data (condition formatting and Macro)

    Hi all!

    I am not sure if this is the right category for my query. Please see attachment for a sample data.
    Here's my problem :
    I would like to change the cell colour for every 15th cell with data - disregarding the blanks.

    Is this possible in Conditional Formatting? I hope it is.
    But if not, any help on Macro will be great!

    Thanks in advance and please let me know if my post is vague.

    Kat
    Attached Files Attached Files
    Last edited by eastydie; 01-09-2012 at 04:56 AM.
    Reply With QuoteRegister To Reply
  2. 01-09-2012, 04:52 AM #2
    zbor
    zbor is offline
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,592

    Re: cell colours for every 15th cell with data (condition formatting and Macro)

    Use: =MOD(COUNTA($B3:B3),15)=0
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 01-09-2012, 04:56 AM #3
    eastydie
    eastydie is offline
    Registered User
    Join Date
    06-11-2010
    Location
    Manila
    MS-Off Ver
    Excel 2007
    Posts
    29

    Re: cell colours for every 15th cell with data (condition formatting and Macro)

    Oh wow that was quick! Thanks zbor! Never thought of MOD function!
    Reply With QuoteRegister To Reply
  4. 01-09-2012, 04:56 AM #4
    zbor
    zbor is offline
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,592

    Re: cell colours for every 15th cell with data (condition formatting and Macro)

    That will also change color on blank position at 16th place (see AE7, AF7)..
    To avoid that use:

    =AND(NOT(ISBLANK(B3)),MOD(COUNTA($B3:B3),15)=0)
    Reply With QuoteRegister To Reply
  5. 01-09-2012, 04:57 AM #5
    eastydie
    eastydie is offline
    Registered User
    Join Date
    06-11-2010
    Location
    Manila
    MS-Off Ver
    Excel 2007
    Posts
    29

    Re: cell colours for every 15th cell with data (condition formatting and Macro)

    alright. thanks again!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1