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
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,
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.