You need to go to conditional formatting:

FormatConditional Formatting

select "Cell Value is" then select "greater than" then type "100" in the
third box

click on the "Format" button and choose the format you want to achieve (in
this case change the font color to red

Hey Presto ! as if by magic

Tel

"WHGRIT" wrote:

I have a simple Excel sum formula ex. =SUM(A1+A2) but if the value (the
answer or total) exceeds say 100; I want the answer to show in red text.
This will alert me there is a problem.

What should the formula look like?