Archive of Mr Excel Message Board
Back to Forms in Excel VBA archive index
Back to archive home
Automatic change of fill colorPosted by Fredrik Pahlm on June 11, 2001 8:23 AM
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!
You're on the right trackPosted 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 trackPosted by Fredrik Pahlm on June 11, 2001 9:01 AM
Thanks a lot for the fast and correct reply!
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.