+ Reply to Thread
Results 1 to 4 of 4

Conditional Formatting Puzzle

  1. #1
    Registered User
    Join Date
    12-06-2023
    Location
    Ontario
    MS-Off Ver
    365
    Posts
    61

    Conditional Formatting Puzzle

    Hello everyone,

    I have a simple time tracker form running and I have a couple of conditional formatting rules in place. But it appears the rules aren't being followed in a particular cell and I can't figure it out.

    CONDITIONS

    1) There are cells for a start time (Column C) and an end time (Column D).
    2) The total time is calculated and if there is a break time (Column F) during that time it is subtracted from the total and displayed in Column L.
    3) There is a total time per side allowed in cell (L6)
    4) The Conditional Formatting rule is simple, if the total time used is less than or equal to the total allowed time (Cell L6), then the cell turns green.
    5) If the total time is greater then the total time allowed (Cell L6), then the cell should turn red.

    NOTES

    1) The formulas and rules worked fine in Cell L35.
    2) It did NOT work in cell L31.
    3) I checked decimal places as far as 10 and they were all 0s.
    4) There is a calculator used to calculate the amount of allowed time (Cell L6), it is based on:
    i) The amount of tables that have to be done.
    ii) The total amount of time per day to work on them.
    iii) The total amount of team members is entered, and the amount of teams they are grouped into.
    iv) Extra Time or Touch-up time can be added which subtracts from the total time available in a day.
    v) The formulas for the calculator are hidden in column P, I forgot to unhide before uploading.

    I am hoping someone can figure out this puzzle, here is a copy of the file. Online Accountability-TEST.xlsm

    Thanks in advance!
    Last edited by Tricks420; 04-20-2024 at 08:10 AM.

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.84 (24041420))
    Posts
    8,755

    Re: Conditional Formatting Puzzle

    yoiu will see in L31
    45.000000000000100000000000000000
    see the 1

    maybe try a round ()
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Registered User
    Join Date
    12-06-2023
    Location
    Ontario
    MS-Off Ver
    365
    Posts
    61

    Re: Conditional Formatting Puzzle

    Awesome, thank you that fixed it. I should have went deeper!!

  4. #4
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.84 (24041420))
    Posts
    8,755

    Re: Conditional Formatting Puzzle

    you are welcome

+ 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. [SOLVED] Conditional Formatting based on another cells Conditional Formatting
    By chriskay in forum Excel General
    Replies: 4
    Last Post: 08-22-2019, 05:33 AM
  2. [SOLVED] Override conditional formatting (in general, without changing the conditional formatting)
    By Stormin' in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-21-2017, 07:15 AM
  3. [SOLVED] Conditional Format Puzzle for me
    By Stryfe in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-17-2017, 07:37 AM
  4. Opening xlsm files with conditional formatting opens with removed conditional formatting
    By Martijn.Steenbakker in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-07-2014, 05:38 AM
  5. [SOLVED] Conditional formatting puzzle. Figure out two different criterions
    By mrjinx007 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 11-07-2013, 07:28 AM
  6. Replies: 1
    Last Post: 09-20-2013, 06:23 PM
  7. Formatting puzzle on dinosaur Excel 2000
    By sb9957 in forum Excel General
    Replies: 0
    Last Post: 08-04-2010, 04:08 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