Results 1 to 10 of 10

Conditional Formatting Using MOD and AND formulas

Threaded View

  1. #1
    Registered User
    Join Date
    04-23-2013
    Location
    Shrewsbury, England
    MS-Off Ver
    Excel 2007
    Posts
    44

    Conditional Formatting Using MOD and AND formulas

    Greetings, trying to conditional format a time entry (start time) if time difference of the preceding (stop time) time entry is less than 8 hrs. Used MOD(B5-H4,1) which gives me the time difference. Trying to use AND(>1,<8) which gives me the 8 hr limit but not sure how I use the conditional drop down to get my original time entry to change to red as per my starting desire. Can anyone make sense of what I am trying to achieve and better still come up with a workable solution? Many thanks as always.

    Eg
    Start Stop Hrs Worked
    08:00 21:00 12:00
    03:00 09:00 06:00

    In the example I am trying to get 03:00 go red on condition it is less than 8hrs between the stop time 21:00 and 03:00 start time. There is a month's worth of start/stop times.
    Last edited by Harrytheb; 11-10-2015 at 09:42 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 with formulas
    By barelyadraft in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 10-18-2012, 02:57 PM
  2. Conditional formatting using formulas
    By masond3 in forum Excel General
    Replies: 18
    Last Post: 11-14-2011, 08:53 AM
  3. Conditional formatting using formulas
    By masond3 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-13-2011, 10:27 PM
  4. Replies: 1
    Last Post: 09-14-2010, 03:45 AM
  5. Excel 2007 : Conditional Formatting With Formulas
    By krt777 in forum Excel General
    Replies: 5
    Last Post: 11-04-2008, 04:57 AM
  6. Conditional Formatting for formulas
    By Mary Frances in forum Excel General
    Replies: 1
    Last Post: 01-04-2008, 06:15 PM
  7. [SOLVED] Conditional Formatting for Formulas
    By Murat Gordeslioglu in forum Excel General
    Replies: 3
    Last Post: 06-22-2006, 04:10 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