SharePoint Conditional Formatting
A Kitemarking system has a maximum of a five star rating which is based on the following:
- Well Defined Data Definition (Question 3 and 4 Has a data value)
- Data warehouse (Question 5 has a data value)
- Technical Data Definition Agreed (Question 6 has a data value)
- Full Accuracy and Assurance Signed Off (Q14 & 15)
- Data has been signed off by the responsible executive (Q12 and Q14 are not blank)
Each bullet above equates to a star for example to get a 5 star rating all items are required.
So in practice the single column called Star Rating could contain 1 - 5 Asterix(s) depending on each of the 8 columns containing a value.
Can anyone help with a Json script that would solve with this requirement?
