J
John C
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
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