I have nine rules in conditional highlighting that work fine. The tenth rule will not work with the same process. I used text with contains and specific text info contained so as to not overlap. Is there a limit on how many rules can be used an a spreadsheet?
MacBook Pro 13″, macOS 12.3
I just tested 13 rules and it works. We could have a better assessment of the situation if you gave the text that is supposed to be conditionally highlighted and a view of the rules.
Press Shift-Command-5, frame a meaningful area, look in the options where the picture file will be saved (desktop by default), and press Enter. Add to the discussion with the second-last icon (mountain and moon) at the bottom of this text field.
Tenth Conditional Highlighting Rule will not work.
