This is similar, but slightly different from the last post. I believed that a new post would be appropriate.
Cell range D5:Q30 is the range that the user sees & uses to enter leave. Cell range AI5:AV30 is what the system uses to conditionally format Cell range D5:Q30 when an individual...