Conditional Formatting with Multiple Formatting

[z168]

Here is what Im trying to do

1) If the TIME is left empty, I want it to go PINK; once filled it will go clear (see B4)

2) If the A column has a date, it will format the next row with a border and shade (Row7)

3) Once the row with the shade is filled, the color goes away and #2 repeats

 

[CWatts]

For the pink shade, use this formula to conditionally format that column.

=AND($B1="",$A1<>"")

For the green shade, use this formula to conditionally format all 3 columns:

=AND($A2="",$A1<>"")