I have 5 Checkbox fields EB, PR, AS, PP & FR.
Condition 1-I would like to turn the ItemColor red if PR is empty and AS or PP or FR are checked (EB does not matter). Can someone help me with an expression to do this?
Condition 2 Advanced version, but not necessary if this is too difficult
Same as above, plus, if any field is checked and all of the preceding fields are not checked ItemColor is assigned blue. Condition 1 has priority.
e.g. EB, PR & PP are checked but AS is not (FR does not matter), ItemColor would be blue.