+ Reply to Thread
Results 1 to 2 of 2

Help! lookup and datedif formula with ages and times

  1. #1
    Registered User
    Join Date
    09-17-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2003
    Posts
    2

    Help! lookup and datedif formula with ages and times

    Hi,

    Trying to set a spreadsheet up with all my swimming clubs personal times on. One sheet of the workbook has the county qualifying times laid out on, with another sheet set up with all four strokes on.

    I want to set up alongside the individual stroke times, some check boxes of conditional formatting which states if their time is faster than their age groups county time.

    Can anyone help! Would be very very helpful!

  2. #2
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: Help! lookup and datedif formula with ages and times

    so, like,

    thisSheet!A1 = their time
    lookupSheet!A1 = qualifying time
    thisSheet!B1 = conditional formatting rule: =thisSheet!$A$1 >= lookupSheet!$A$1; TRUE, change color to green; FALSE, change color to yellow

    Well, you might have this formatted row-wise or something, depending on how it's aligned?

    Anyway if you post and example sheet, a worked example can be thrown back to you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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