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

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

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

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


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=574445

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

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

"davesexcel" wrote:


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


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=574445