+ Reply to Thread
Results 1 to 5 of 5

Multiple condition, multiple range formating

  1. #1
    Forum Contributor
    Join Date
    10-03-2005
    Posts
    185

    Multiple condition, multiple range formating

    In range C15:C45 I have names of some steps. Starting from column D, row 6 have a drop down with 6 possibilities. Now based on what is selected in row 6 (so cell D6, E6, F6 and so on), I would like to color certain cells from 15 to 45 in that particular column (certain steps that are applicable to option selected in row 6 of that column). And as month goes by, users do that in more and more columns.
    Also, steps overlap between conditions that are selected in row 6 and I would like this to macro (or formulae) to be running so that as soon as user selects the condition cells are colored and then they can fill out only those cells.

    So, I couldn't figure out any way to do this by conditional formating as there are more than three conditions and range is not continuous.Please see attached file as an example of final output.

    Any help would be greatly appreciated.

    Thank you in advance,
    Jay
    Attached Files Attached Files
    Last edited by sa02000; 04-11-2009 at 09:12 AM.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Multiple condition, multiple range formating

    Hello sa02000,

    No one has answered your post, because it lacks any concrete examples of what you want to do. You need to detail what your conditions will be and which color you want associated with which condition.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Forum Contributor
    Join Date
    10-03-2005
    Posts
    185

    Re: Multiple condition, multiple range formating

    Leith,
    I submitted an example output to be specific but as far as color are concerned it doesn't really matter which condition have which color and color is something that can be easily changed anyway. Or am I missing something else?

    Jay

  4. #4
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Multiple condition, multiple range formating

    This uses a Worksheet_Change macro to watch row 6 from D6 on. It uses an array of "steps" listed in a Select Case Value test.

    All you need to do is enter the step #s in each Condition. After your original 3 samples, I added 3 more sets of random step selections to show the colors in action.
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by JBeaucaire; 04-11-2009 at 06:35 AM. Reason: Added row variance to macro
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  5. #5
    Forum Contributor
    Join Date
    10-03-2005
    Posts
    185

    Re: Multiple condition, multiple range formating

    Super Excellence! Just tried it and Works perfectly.
    Thank you very much.

    Jay

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1