+ Reply to Thread
Results 1 to 9 of 9

Conditional Formating

  1. #1
    Registered User
    Join Date
    05-06-2013
    Location
    Illinois
    MS-Off Ver
    Excel 2007
    Posts
    14

    Conditional Formating

    I have a spreadsheet which Contains Start Times & End Times for an Operator & a different time for the Helper. First i would like to format Each row of 14 columns based off of one cell in each row. i have three different "words" that would change the color of the row. If Setup = Yellow, if Up = Green, if Down = Red. Then i would like to add all of the setup's, all of the up, and all of the downs together, as there will be different times in each cell.

    Help...........Please!
    Attached Files Attached Files

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Conditional Formating

    Please add some manually calculated results so that we can see the end goal.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Conditional Formating

    I have attached a modification to your file that handle the Up and Down cases. I assumed that the yellow that is already there is what you want to Setup so new rule is necessary. However, if you do want a special color of yellow for Setup then you can see what I did and add another rule.

    Quote Originally Posted by Sandra_Sada View Post
    Then i would like to add all of the setup's, all of the up, and all of the downs together, as there will be different times in each cell.
    I have no idea what you mean by this.
    Attached Files Attached Files
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Conditional Formating

    1. highlight the range you want to apply the conditional formatting to ($A$3:$N$178)
    2. on the home tab, styles, select CF
    3. select new rule, select use formula
    4. enter =$N3="Setup"

    Repeat 3 and 4 for "up" Green, "down" Red and "" White (the "" is to catch rows with nothing in N)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  5. #5
    Registered User
    Join Date
    05-06-2013
    Location
    Illinois
    MS-Off Ver
    Excel 2007
    Posts
    14

    Re: Conditional Formating

    Attached is an example, per your request. but there is no formula's, as that is beyond me.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    05-06-2013
    Location
    Illinois
    MS-Off Ver
    Excel 2007
    Posts
    14

    Re: Conditional Formating

    thanks........ i really don't know how you did it, but it worked, lol. I do want to add another rule for the "setup".

    you stated you have no idea....... theoretically, there would be "durations" in the J & M column. ie.......2 minutes, 4 minutes for set up. 6 minutes, 8 minutes for down and so forth. i would want something to talley all of the setup (6 minutes), down(14 minutes) and up durations together.

    does that make sense?

  7. #7
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Conditional Formating

    If you want to sum ALL the setups etc, then use the SUMIF() function. Something like...
    =SUMIF($N$3:$N$178,"Setup",$J$3:$J$178)+SUMIF($N$3:$N$178,"Setup",$M$3:$M$178)
    Replace "setup" with "Up" and "down" for the other 2 totals

  8. #8
    Registered User
    Join Date
    05-06-2013
    Location
    Illinois
    MS-Off Ver
    Excel 2007
    Posts
    14

    Re: Conditional Formating

    Thanks for all of your assistance.

    how do i close this thread?

  9. #9
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Conditional Formating

    You don't close it, but you mark it as solved.

    Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

    If a member helped you solve your problem, consider adding to their reputation by clicking on the star icon below their name.

+ 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: 5
    Last Post: 03-14-2014, 04:03 AM
  2. Replies: 4
    Last Post: 01-23-2014, 10:14 AM
  3. Replies: 6
    Last Post: 08-14-2006, 05:00 PM
  4. Replies: 2
    Last Post: 03-27-2006, 12:10 PM
  5. Install dates formating using conditional formating?
    By Jerry Eggleston in forum Excel General
    Replies: 2
    Last Post: 11-09-2005, 01:49 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