Conditional formatting for dashboard

Excel Office Professional Plus 2016   Attached is a list of the healthcare patients at my work. I am trying to create a rudimentary dashboard to keep track of patient documentation. I want to use t...