+ Reply to Thread
Results 1 to 4 of 4

Multiple colour choice - Conditional Format

  1. #1
    Registered User
    Join Date
    10-25-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    6

    Multiple colour choice - Conditional Format

    Hi Everyone

    Need a little help please with conditional formatting. Example file attached that shows where I have got up to so far.

    Example 1 - conditional formats specific calendar dates Green for completed and Red for incomplete days
    Example 2 - conditional format specific dates for specific number of days
    Example 3 - conditional format specific row according to colour choice from data validation drop down colour choice.

    Example 4 - This is where I need help I would like to conditionally format from start date to end date or start date for actual number of days but be able to choose what colour the row is as in example 3.




    Any help much appreciated
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-20-2015
    Location
    Chicago, Illinois
    MS-Off Ver
    2016
    Posts
    2,105

    Re: Multiple colour choice - Conditional Format

    If I'm understanding your request correctly, then you just need to combine examples 2 and 3 to achieve example 4. Create 5 CF rules (one for each color) using AND clauses:

    =AND(L$1>=$E$18,L$1<$E$18+$G$18,$D$18="Green")

    Hopefully that does the trick?
    Attached Files Attached Files
    If your problem has been solved, please use "Thread Tools" to mark the thread as "Solved".

    If you're grateful for this site's existence and would like to contribute to the community, please consider posting something hilarious in our joke thread:
    https://www.excelforum.com/the-water...ke-thread.html

  3. #3
    Registered User
    Join Date
    10-25-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Multiple colour choice - Conditional Format

    CAntosh many thanks always appreciated had my head on backwards and when you see the answer the solution was in front of me.
    Last edited by AliGW; 07-19-2019 at 10:16 AM.

  4. #4
    Forum Expert
    Join Date
    05-20-2015
    Location
    Chicago, Illinois
    MS-Off Ver
    2016
    Posts
    2,105

    Re: Multiple colour choice - Conditional Format

    My pleasure, good luck!

+ 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. Conditional Format multiple rows with colour
    By MattExcelLearner in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-19-2018, 06:03 AM
  2. Multiple Choice Conditional Format
    By droddis in forum Excel General
    Replies: 6
    Last Post: 03-13-2017, 11:30 AM
  3. [SOLVED] Help with Conditional Formatting For Creating Multiple Choice Drop Down Test
    By dn7309 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 05-26-2015, 05:25 AM
  4. Conditional Format colour Text
    By Puggwash63 in forum Excel General
    Replies: 4
    Last Post: 12-13-2014, 09:08 AM
  5. Conditional formatting for grading multiple choice exam
    By mandm1516 in forum Excel General
    Replies: 2
    Last Post: 04-30-2012, 10:38 AM
  6. Multiple Time Stamps depending on choice in Drop Down List Choice
    By insayah in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-13-2011, 10:18 PM
  7. Conditional Format colour
    By meridklt in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-04-2007, 05:19 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