Looking to 'visualize' errors based on a few conditions

I have a data set that management wants to be able to visually see items out of 'compliance' based on a set of criteria:   Rules: If status is blank, that’s an error If dates are past, and statu...