Producing a grade in a specific colour

  • Thread starter Thread starter Noel S Pamfree
  • Start date Start date
N

Noel S Pamfree

In order to warn me if a student is falling behind in their grades, I would
like my lookup table to show a poor grade in red and a border line grade in
orange. This way it will alert me to talk with the students concerned.

I know it can be done as I saw it on a colleague's Excel spreadsheet in my
last school. I can't find out how to achieve it.

Can anyone give me some help?

Thanks,

Noel
 
Click on the cell you want to format, then Format > ConditionalFormatting >
and follow the menu..........post back with specifics if you run into
problems........

Vaya con Dios,
Chuck, CABGx3
 
Thanks so much - it's very straight forward once you know about the menu.

Great!

Noel
 
Back
Top