How do I auto-highlight a 'below limit' number in an average

[DJ]

I'm trying to create a gradesheet in which any score that falls into the
failing range will automatically highlight in red...

 

[davesexcel]

highlite the range and at the top menu select format and conditional
format

Here's a site that explains

http://www.contextures.com/xlCondFormat01.html

 

[DJ]

That's exactly what I was looking for!! Thank you!!!