Use conditional formatting. If you attach your workbook its more helpful.