Hi!

You need to create a 2 column table that lists the market and its goal
(based on your sample data):

.................H...................I
1.........Market...........Goal
2........Chicago.............4
3......New York...........7

Then, assume your other data is in the range A2:C6.
Select the range A2:A6.
Goto the menu FormatConditional Formatting
Select Formula Is and enter this formula in the box to the right:

=C2=VLOOKUP(B2,H$2:I$3,2,0)

Click the Format button.
Select the style(s) desired.
OK out

Biff

"John C" wrote in message
...
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