For the 2nd part, try this in P6, copied down...
=IF(COUNTA($H$26:$I$29)>0,10,0)
(although you have $50 in that column now?)