Archive of Mr Excel Message Board
Back to Forms in Excel VBA archive index
Back to archive home
Cell Colour change
Posted by Steve Webb on July 10, 2001 11:42 AM
I have used a simple Ranking formula, but would like to change the background colour for visual effect for Fail/Pass. Say Red for fail & Green for pass. Is there a macro that will do this automatically?
Thanks in advance
Steve
Re: Cell Colour change
Posted by Mark W. on July 10, 2001 11:53 AM
Consider using Conditional Formatting.
Re: Cell Colour change
Posted by Ben O. on July 10, 2001 11:56 AM
Try using Conditional Formatting (select Format > Conditional Formatting). Enter your two conditions and the formats associated with them, then use the format painter to apply that conditional formatting to your entire column.
-Ben
Re: Cell Colour change
Posted by Steve Webb on July 11, 2001 12:29 PM
Many thanks for your help
Steve
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.