Multiple Conditions for Conditional Formatting

Attached is a sign-in sheet that I'm working on..

I want to set conditional formatting for columns a:c based on whether the employee is in the building or not.. However, because I have two columns that indicate the employee is out of the office (Time Out Break & POSH Out), one rule is basically overridden by the other. I'm sure there's an easy way to do it, I just haven't been able to figure it out..

What I want is for the Employee column to be formatted as follows:
-Time In (Day Begin) D7:D29 populated: Blue
-Time Out (Break) E7:E29 populated: Gray
-Time In (Break) F7:F29 populated: Blue
-POSH Out G7:G29 populated: Gray
-POSH In H7:H29 populated: Blue
-Time Out (Day End) L7:L29 populated: Gray

Ultimately, I want the employee cell to be blue if they're clocked in (Time In Day Begin, Time In Break or POSH In is populated) BUT turn gray if they've clocked out (Time Out Break, POSH Out, Time Out Day End) after they've clocked in.

Break Time (Columns D & E) may be before or after POSH time (Columns G & H) and I think that's where I'm getting hung up.


Any help would be appreciated.