Results 1 to 58 of 58

personnel performance scorecard

Threaded View

  1. #29
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,077

    Re: personnel performance scorecard

    For the traffic lights the conditional format can only handle absolute references (e.g. $K$3).
    You probably created the conditional format for the 1st row and then copied the format to the other rows.
    With relative references (e.g. K3) Excel would automatically adjust the reference, but not so with absolute references.
    That makes that the conditional format of he 2nd row etc keeps looking at the first row (i.c $K$3) and so the 1st row seems to work and the others don't.

    To solve this I inserted an additional column holding the formula of the conditional format, but it's only showing the trafic light. That's an option you can set.

    Added some additional comments in the attached sheet.

    Will get back to you about to other things.
    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. Ship's personnel spreadsheet
    By Anton1888 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-27-2013, 06:40 AM
  2. Solver for personnel project allocation
    By sunrise85 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-13-2011, 11:20 AM
  3. Looking for a template for personnel courses
    By C Holmes in forum Access Tables & Databases
    Replies: 3
    Last Post: 10-25-2010, 04:02 PM
  4. Replies: 9
    Last Post: 10-04-2009, 01:09 PM
  5. Personnel Costs - HELP
    By incognito in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-13-2006, 02:12 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