Excel formula
 

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?

Excel formula
 

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?

Excel formula
 

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.

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?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200603/1