Archive of Mr Excel Message Board


Back to Forms in Excel VBA archive index
Back to archive home

Automatic change of fill color

Posted by Fredrik Pahlm on June 11, 2001 8:23 AM
Hi,
I would like to change the fill color of a cell depending on if the value is positive or negative. I.e. a cell with a positive value should become green and a cell with a negative value should become red. I know that it is possible to automatically change the font color in the "Format cells", but I have not found a way to change the fill color this way.

Any suggestions will be greatly appreciated!

Regards

Fredrik


You're on the right track

Posted by Eric on June 11, 2001 8:33 AM
You've almost got it. The third tab over under conditional formatting under "format cells" is called patterns- there you can change "cell shading", which is what I think you're after.


Re: You're on the right track

Posted by Fredrik Pahlm on June 11, 2001 9:01 AM
Hi Eric,
Thanks a lot for the fast and correct reply!

// Fredrik


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.