Setting colors of results in a column
 

I have sets of student marks and I want the column to automatically show
failures (<50%) in red. All other marks in black.

How do I do this?

Setting colors of results in a column
 

http://www.contextures.com/xlCondFormat01.html
"ERBERB" wrote:

I have sets of student marks and I want the column to automatically show
failures (<50%) in red. All other marks in black.

How do I do this?