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


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.


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

Many thanks for your help