Order of Conditions for Conditional Formatting

Since I posted my reply, I thought I'd better try it myself. You were right it is a difficult one, but I think I now have the answer

First of all, click the little square in the top left hand corner to select the whole sheet, then apply CF in the "Formula as"

=MOD(ROW(),2)

Then select row 1 and delete the CF from that row

Select A1 default the cell colour to Blue background, by "Format cells"

Then apply CF to A1, condition 1

=IF(OR($A$1="",MOD(ROW(),2),$A$1>TODAY()-2,$B$1<>"Finished"),) apply Blue background

condition 2

=$A$1-TODAY()<2 apply Blue background, Red bold text

condition 3

=$B$1="Finished" apply Green background

Then select B2 and apply CF, condition 1

=IF($B$1<>"Finished",MOD(ROW(),2)) apply Blue background

condition 2

=$B$1="Finished" apply Green background

Now to get the remainder of row 1 to turn Blue or Green, click on B1,click the Paintbrush icon, and apply it to C1:IV1

Just in case a copy of the sheet is attached, so that you can see yourself.

Hope this is what you want.