Results 1 to 12 of 12

Conditional Format not working properly

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-13-2015
    Location
    Culloden, West Virginia
    MS-Off Ver
    2010
    Posts
    168

    Conditional Format not working properly

    I have a sheet that calculates overtime. One cell, U11, shows my total OT. When accounting for my OT I can split it into three different categories in cells X11, Y11, & Z11.
    What I'm trying to accomplish... I manually input totals into X, Y, & Z, when they equal U, I want X, Y, & Z to turn Green as a visual indicator that I've accounted for all my OT.

    I can not get this to work. If I manually type in my OT in U11 the conditional formatting works, but if I let the formulas calculate my OT in U11, the conditional formatting does not work.

    This worked for me previously when we tracked time in tenths, but we switched to minutes and after I've adjusted my sheet for this I can't get it to work.

    I've attached the sheet that I'm working on. I've only been working on row 11 with the intent of copying everything down once I figure it out.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Conditional cell formatting not working properly
    By luv2glyd in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 01-06-2017, 12:49 AM
  2. [SOLVED] Conditional Formatting not working properly
    By Hodge1013 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-23-2015, 07:42 PM
  3. [SOLVED] Macro not working properly for conversion of date format
    By abraham30 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-14-2014, 10:46 AM
  4. Conditional Formatting Formula Not Working Properly
    By Oscar Martin in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-23-2014, 08:59 AM
  5. [SOLVED] Conditional Formats Not Working Properly When Copied
    By Oscar Martin in forum Excel General
    Replies: 2
    Last Post: 01-28-2014, 01:48 PM
  6. Conditional formatting not working properly
    By mlucey01 in forum Excel General
    Replies: 4
    Last Post: 01-08-2013, 08:35 PM
  7. [SOLVED] Conditional Formatting using VBA - Code not working properly
    By Tejas.T in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-07-2012, 10:19 AM

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