Feb 14 2019 12:35 PM
Feb 14 2019 01:33 PM
You may apply to column B conditional formatting rule for the green with formula
=$B1>0.7*$A1
assuming your range starts from first row. Similar for the red rule.
Feb 14 2019 02:01 PM
Feb 14 2019 03:27 PM
It works for your entire range
Please see attached