Results 1 to 4 of 4

Colour Coding Cells If Contracted Hours Not Met

Threaded View

  1. #1
    Registered User
    Join Date
    08-06-2011
    Location
    North West
    MS-Off Ver
    Excel 2003
    Posts
    25

    Colour Coding Cells If Contracted Hours Not Met

    Hi,
    I want to create a time card which will generate colour coded warning if someone works either more, or less than their weekly contracted minuets.

    Required:

    If someone works less than 2,250 minutes (37.5 Hours), then wherever that employees name appears in the 5 time cards, the cell glows RED
    If someone works more than 2,250 minutes (37.5 Hours), then cell glows GREEN
    If someone works 2,250 minutes (37.5 Hours) exactly, then cell remains unchanged

    The cell to be coloured is the cell in column B containing the name

    Cells which have been greyed out will be hidden from view

    Please see attached sample sheet.

    Many Thanks,

    Sean
    Attached Files Attached Files
    Last edited by suma; 01-03-2012 at 07:25 PM.

Thread Information

Users Browsing this Thread

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

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