Did you try using Conditional Formatting?