I have the need to set the color of a cell, based on whether the value
equals one of a series of values on another worksheet.

The situation is, we do tire testing. We measure the tires, and/or perform
vehicle validations, at certain mileage intervals. These intervals change
based on the type of test it is. I'd like to be able to have a "setup"
sheet that has the particular mileages that certain operations are
performed, keep track of the mileages run each day on that sheet. Then, on
a separate worksheet, keep a running list of the totals for each day, and if
the total for a particular vehicle/set of tires matches one of the values on
the setup sheet, set the cell color to something to stand out, showing it
needs some type of work done.

How can I do this? Can I do this?

Thanks!
Shawn