I need to create a rule where if one cell contains specific text (‘Yes’), it highlights in one colour (yellow) and then if another ‘Yes’ is present in the cell next to it (same row), then the second ‘Yes’ cell will turn Orange and the red for a third ‘Yes’.
Is this possible?
Or – (for example) if C1 contains ‘Yes’, then a A1 and B1 turns yellow, and if D1 also contains a ‘Yes’, the A1 and B1 turns orange and so on.
Thank you in advance!!