1

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.