Thanks Glenn, how about the part where the entire row's color change to red when the date today is the same as column E. yellow when today's date is the same as column D.