if x then autofill a color

[epankow]

I want a cell to fill in a color if the result is positive and another
color if teh result is negative.

I can use the if - then function fairly well but I cannot figure out
how to get a cell to fill in a color based on the result.

How do I get this to work?

 

[Laura Cook]

Try using Conditional Formatting.

http://www.cpearson.com/excel/cformatting.htm

Laura Cook