Using the SUMIF function, i would like answers returned that are < to be in
red font, and when the answer is = (ie the correct answer), for it to be in
black font.

is there a way of conditional font formatting?

Thanks in advance.

Mel