Excel Formatting (2000)

Topic

New Reply

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.

Reply | Quote

Replies

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

Reply | Quote

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.

Reply | Quote

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

Reply | Quote

Thanks!

Reply | Quote

Thanks!

Reply | Quote

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

Reply | Quote

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.

Reply | Quote

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

Reply | Quote