yogi_Conditionally Format Rows A:E Depending On Entry In Column B

Google Spreadsheet   Post  #2258

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Oct-05-2017

Question by Change row ...

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/p68eH_b6Ils;context-place=mydiscussions
How to change a row color in a google sheet based on score row from a google form?
I am trying to use conditional formatting to have my google sheet automatically change a rows color based on the score that is formulated in one of the rows from the quiz taken in google forms.  I think part of the problem is that the score row from forms shows up as 1/2 or 3/5.  I am assuming that I will need to convert the score to some other value somehow and create a custom formula for conditional formatting.