Results 1 to 3 of 3

Enter data in cell and the next cell decreases value by 1

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-24-2013
    Location
    NY,NY
    MS-Off Ver
    MS 365
    Posts
    250

    Enter data in cell and the next cell decreases value by 1

    I"m sorry I'm new to this forum and I've tried almost everything possible. I researched the internet for an answer but nothing yet. If you can steer me in the right direction.

    Basically I have a list of technicians that have to perform projects on a quarterly basis. Column A is labeled tech # column b is labeled visits. Now they begin with 4 visits a year. I would like to enter their technician number 636 in a2, then b2 will decrease from 4 to 3. Therefore that specific technician has 3 pm's left for the year. Also I would like to highlight the pm's while they are at 4 so when they fall to 3 the cell will no longer be highlighted. Is this possible?

    Thank you,
    Attached Files Attached Files
    Last edited by thursday140; 01-25-2013 at 10:58 AM.

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