+ Reply to Thread
Results 1 to 5 of 5

Need help to Make random color based on multiple criteria

  1. #1
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Need help to Make random color based on multiple criteria

    Hi Masters,

    I am here with my query, query is below

    requirement is, I have list name and date start and date end and I unable to understand how to explain , if u check the attached file u will understand easily I hope

    example: u can example in attached File

    so far I made below code
    Please Login or Register  to view this content.
    please do let me know if I am not clear on query

    Thanks in Advance.
    Attached Files Attached Files
    Thanks - Naveed
    -----------------------------
    If the suggestion helps you, then Click * to Add Reputation
    To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
    1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

  2. #2
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Re: Need help to Make random color based on multiple criteria

    U can see the attached file for example , I hope this will give u perfect picture what I exactly I want
    Attached Files Attached Files

  3. #3
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Need help to Make random color based on multiple criteria

    Hi Naveed Raza,
    maybe so
    Please Login or Register  to view this content.
    Attached Files Attached Files

  4. #4
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Re: Need help to Make random color based on multiple criteria

    Hi Nilem

    thanks for replying quick !!

    unfortunately its assigning color incorrect see the snapshot

    left side is your code output and right is actual output
    Attached Images Attached Images

  5. #5
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Need help to Make random color based on multiple criteria

    Oops
    this line
    Please Login or Register  to view this content.
    should be "k" instead of "i"

+ 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. Cell Fill Color based on multiple criteria
    By Mr Teafortwo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-11-2014, 02:00 PM
  2. need help! To make multiple sheets from one excel sheet based on criteria
    By magicgolub in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 09-15-2014, 07:11 AM
  3. Replies: 6
    Last Post: 06-17-2014, 11:11 AM
  4. [SOLVED] Need IF statement or Macro to make decision based on multiple criteria
    By weddica in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-25-2013, 03:30 PM
  5. VBA-Fill color based on multiple criteria
    By kimmie in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-31-2011, 05:46 PM

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