Results 1 to 4 of 4

Conditional Formatting Puzzle

Threaded View

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

    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.

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