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?

I finally got it - trouble came in that I tend to right click to do most of my work and the right click does not bring up the option of conditional formating. Oh happy day -

Try using Conditional Formatting.

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

Laura Cook



"epankow" wrote in message
...

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?




--
epankow