Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Nov 2003
    Location
    Nebraska
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel Formatting (2000)

    I have constructed an Excel spreadsheet where individuals scan in serial numbers and put their name or initials next to their serial number. I would like to be able to color and total the serial numbers with an asterisk at the end of a name denoting something is wrong with the serial number. Any ideas? Here is an example.

  2. #2
    Lounger
    Join Date
    Feb 2004
    Location
    Buffalo, New York, Wales
    Posts
    40
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Formatting (2000)

    I assume that your techs manually enter there name and the asterix (*) when there is a problem with the serial number. If this is not the case let me know how you want it to work. Your explantion didn't explain it clearly.

    I added conditional formatting that changes the serial number cell to a different color and the font to red when the tech name has a * at the end.
    I also used your formulas on the summary sheet to count the number of names with *.

    Let me know if this is what you are looking for.

    yoyoPHIL

  3. #3
    New Lounger
    Join Date
    Nov 2003
    Location
    Nebraska
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Formatting (2000)

    Yes they do manually enter their names and asterix. What I would like to do is have anything with an asterix at the end be totaled in the "All Others" part of the "Summery" sheet.

  4. #4
    Lounger
    Join Date
    Feb 2004
    Location
    Buffalo, New York, Wales
    Posts
    40
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Formatting (2000)

    Hows this?

    Technically it is not looking for the asterix (*) but instead it counts all the entries for the specific date and then subtracts the total jobs done by the techs as calculated by your sumproduct formula.

    Let me know if this is what you need.

    yoyoPHIL

  5. #5
    New Lounger
    Join Date
    Nov 2003
    Location
    Nebraska
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Formatting (2000)

    Thanks!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •