if x then autofill a color

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

epankow - 01 Feb 2008 18:39 GMT

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?

Signature

epankow

Reply to this Message

Laura Cook - 01 Feb 2008 20:10 GMT

Try using Conditional Formatting.

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

Laura Cook

> I want a cell to fill in a color if the result is positive and another
> color if teh result is negative.
[quoted text clipped - 3 lines]
>
> How do I get this to work?

Reply to this Message