I'm trying to conditionally format a range of cells to turn colors based upon certain criteria.  General notion: If E3 = unpaid and G1<=10, then turn A3-G3 red.  If E3=unpaid and G1<=30 and >=11 then turn A3-G3 Yellow, If E3 = unpaid and G1>30 then turn A3-G3 Green.  If E3 = paid then cell remain white.  
Conditionally Formatting Google Sheets
google spreadsheets;conditional formatting