Have you tried conditional formatting?