Archive of Mr Excel Message Board

Back to Dates in Excel archive index
Back to archive home

To put colors depending the result of a formula.

Posted by Raul on January 12, 2001 8:38 AM

Hello,
I'm a very low level user, so please forgive me if I'm asking something stupid.
The question is if it's possible to put the result of a formula, or the fill color of a cell, in one color or other depending of the result.
I mean, if the result is possitive I'd like green color and if it's negative I'd like red.

I suppose that it's quite simple, but ......

Thanks in advance,
Raul.

Re: To put colors depending the result of a formula.

Posted by Tony Scala on January 12, 2001 8:47 AM

Try using Conditional Formatting under the format tab of the title bar.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.