Good Morning!
I would love some help with some conditional
formatting. I have a form that is based off of a SharePoint 2010 List.
The form consists of a bunch of drop down boxes. Based on the users
selections I assign a value to their answer. Then using hidden fields I
total the scores up into two categories. No problems there. I have
tested the form out and am getting the correct scores for 2 different
categories. I then have to compare the final scores for category A and
category B, and depending on the range the scores fall into I have to
assign a value to a text box. Basically I'm trying to duplicate the
following matrix
So basically if the total score for category A falls between 0-83 AND the total score for Category B falls between 0-166 set field Y to "Bad"
I've attempted multiple things - but keep running into problems. Any help would be appreciated!