Hi Peoples; -
Col X is string of (formulated) text entries which may contain "r" or "g" (or non-relevant others).
Col Y is string of values and (formulated)text
Requirement is to highlight Y cells in one colour if
=AND(Xnn="r",Ynn=1) in (say) red
=AND(Xnn="g",Ynn=1) in (say) green