Excel formula

W

WHGRIT

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?
 
T

Tel

You need to go to conditional formatting:

Format>Conditional 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
 
L

L. Howard Kittle

A formula can only return a value to a cell, not format the text or the cell
etc.

Using Conditional Formatting under Format can highlight the cell to a color
to alert you.

Cell Value Is > Greater than > 100 > Format > pick a color > OK out

HTH
Regards,
Howard
 
P

pau1a via OfficeKB.com

You can do this using conditional formatting.

Go to click on cell with answer in, then go to format, conditional formatting.
Its self explanatory from there.
 
Top