Conditional formatting / formulas

[Julie]

I set up a table with a list of states in one column and amount of
tons in another column (ex from the book). I set up a conditional
format in a cell above the table to highlight all similar states when
entered in the above cell; ex: when I type IOWA, all IOWA listings
will be highlighted in the list. Then I tried a formula next to that
one that will add all the tons for each of the highlighted states. I
looked on the Internet and found a formula using MATCH but it only
entered the amount from the first IOWA, not the rest.

Does anyone have any idea how I would write that formula. Would I use
the COUNTIF function somehow?

 

[Bob Phillips]

Assume that the entry cell is A1, and the data is in A2:B100, select
A2:B100, and then goto conditional form atting and add this formula

=$A2=$A$1

and format to taste