MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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


Posted by Mark W. on July 10, 2001 11:53 AM

Consider using Conditional Formatting.

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

Posted by Steve Webb on July 11, 2001 12:29 PM

Many thanks for your help


Steve