ok so in column B I have "Market" (Chicago, new york, etc.)
In column C I have Total Sales

The goals for total sales are different for each market. How do I Underline
the values in all cells that exceed a certain value depending on the market.

Example: Goal for Chicago is 4; Goal for New York is 7

Name Market Sales
John Chicago 4
Jed New York 6
Anne Chicago 5
Suzie Chicago 3
Joey New York 8

Market can be any 1 of 32 cities & Sales ranges a lot too. It takes me an
hour a day to sort through 200+ employees' stats to see who met goals and who
didnt, and then to Highlight the ones who did.

I would be willing to paste code that accomplishes this, or to use
conditional formatting but I can't figure out how to make that fit my search
conditions.

Please Help