+ Reply to Thread
Results 1 to 8 of 8

Excel Conditional Formatting based on two cells one cell containing minutes and seconds

  1. #1
    Registered User
    Join Date
    11-19-2019
    Location
    Victoria, BC Canada
    MS-Off Ver
    Office 365 Office 2016
    Posts
    8

    Excel Conditional Formatting based on two cells one cell containing minutes and seconds

    Trying to do conditional formatting based on text value in column B containing and if column F is greater then 1 minute 30 seconds.
    This is what I have but it's not formatting the colour to the row.

    =AND($B2="ACW", $F2>"00:01:30")

    Basically looking for check column F for greater then 1minute 30 seconds and highlight the row if Column B says ACW.
    Attached Files Attached Files
    Last edited by Masks44; 11-19-2019 at 03:09 PM.

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Excel Conditional Formatting based on two cells one cell containing minutes and second

    Hello and welcome to the forum.

    I recommend uploading a small representative sample workbook (not picture) of your data along with the desired results (which you can enter manually) based on that data.

    To upload an Excel workbook, follow these steps:
    1) Click on "Go Advanced"
    2) Click on "Manage Attachments"
    3) Click on "Choose File"
    4) Choose your file and click on "Open"
    5) Click on "Upload"
    6) Click on "Close this window"

  3. #3
    Registered User
    Join Date
    11-19-2019
    Location
    Victoria, BC Canada
    MS-Off Ver
    Office 365 Office 2016
    Posts
    8

    Re: Excel Conditional Formatting based on two cells one cell containing minutes and second

    File now attached in original message, thanks

  4. #4
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Excel Conditional Formatting based on two cells one cell containing minutes and second

    Highlight A2:G84 (or however far your data goes) > Conditional Formatting > New Rule > Use a formula
    =AND($B2="ACW",$F2>TIME(0,2,0))
    Format: Fill Orange > OK > OK

    Highlight A2:G84 (or however far your data goes) > Conditional Formatting > New Rule > Use a formula
    =AND($B2="UnScheduled Break",$F2>TIME(0,5,0))
    Format: Fill Blue > OK > OK

  5. #5
    Registered User
    Join Date
    11-19-2019
    Location
    Victoria, BC Canada
    MS-Off Ver
    Office 365 Office 2016
    Posts
    8

    Re: Excel Conditional Formatting based on two cells one cell containing minutes and second

    It's not working, same problem I had before it's highlighting the wrong rows it's not selecting the correct rows from Column B

  6. #6
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Excel Conditional Formatting based on two cells one cell containing minutes and second

    It didn't work because you didn't follow the instructions from post #4 precisely.

    I can see in your attached workbook from post #5 that you highlighted A:G instead of A2:G84.
    When you do this, the first row that the CF is applied to is row 1 so you would have to use row 1 in your formulas instead of row 2.

  7. #7
    Registered User
    Join Date
    11-19-2019
    Location
    Victoria, BC Canada
    MS-Off Ver
    Office 365 Office 2016
    Posts
    8

    Re: Excel Conditional Formatting based on two cells one cell containing minutes and second

    Thank you that worked me bad.

  8. #8
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Excel Conditional Formatting based on two cells one cell containing minutes and second

    You're welcome. Happy to help.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

+ 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 formatting involving minutes and seconds
    By cbenner3017 in forum Excel General
    Replies: 4
    Last Post: 06-21-2019, 11:37 AM
  2. [SOLVED] Conditional formatting of cells with minutes as the cell values
    By cbenner3017 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 11-28-2018, 11:53 AM
  3. Excel time formatting (hours, minutes, seconds)
    By johncena69 in forum Excel General
    Replies: 3
    Last Post: 01-02-2017, 12:52 AM
  4. Excel 2010: Formatting minutes and seconds
    By Mase1 in forum Excel General
    Replies: 1
    Last Post: 04-17-2013, 05:49 PM
  5. Replies: 3
    Last Post: 04-30-2011, 11:46 PM
  6. Formatting minutes and seconds
    By davidstrongarm in forum Excel General
    Replies: 1
    Last Post: 11-21-2010, 03:08 AM
  7. [SOLVED] formatting cells for minutes:seconds
    By b in forum Excel General
    Replies: 1
    Last Post: 05-10-2006, 05:20 PM

Tags for this Thread

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