Archive of Mr Excel Message Board

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

Changing the Backcolor

Posted by Paul on June 20, 2001 2:16 AM

Is there away that I can change the backcolor of a cell that has a certian value in it so that when the value is typed in the backcolor of the cell changes.

Thnaks in advance
Paul.

Re: Changing the Backcolor

Posted by C on June 20, 2001 6:00 AM

Re: Changing the Backcolor

Posted by Connie on June 20, 2001 6:03 AM

Paul,
What you need is called Conditional Formatting, and it is found under the Format menu. Once in conditional formatting, set the criteria for whatever value you want to trigger the color change, i.e. >, <, =, then go to Patterns on that submenu and select whichever color you'd like the cell background to change to.
Connie

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.