Conditional Formatting: comparing cell values

C

Coco212

Using MS 2007, I have a column that has 40 sets of three rows; the rows are
for three seperate years for 40 different schools that are included in the
chart.

The cells I am workign with show the performance indicator - a number - for
each of the three years for the school in that set.

I need to compare the three numbers for each set and show which set of three
shows gains, and eventaully determine the highest performer over the three
years.

Sample:
# SCHOOL YEAR
60 AVE 2008-09
61 AVE 2007-08
53 AVE 2006-07
69 BCE 2008-09
53 BCE 2007-08
56 BCE 2006-07
63 CPE 2008-09
64 CPE 2007-08
84 CPE 2006-07

How do I conditionally format the sets of numbers to show gain or loss
compared to the row beneath it?

Or a better suggestion for finding the highest performing school considering
the three years of performance?
THANKS!
Synthia
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top