Compound rules in the Numbers app?

I am trying to create a set of rules in Numbers that will result in the following:


  • If the cell contains a single "dash", i.e. the single character "-", it will be highlighted green
  • If the cell contains any other characters, i.e. is not empty, it will be highlighted red
  • If the cell is empty, it will have no highlighting


No set of rules I've entered yet has enabled this result, and I've spent a decent amount of time typing in different search strings into my search engine with zero luck so far... :(


Is it possible to get this result? And if yes, how?


Thanks!

MacBook Pro 13″, macOS 13.4

Posted on Jul 12, 2023 11:14 AM

Reply
3 replies

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Compound rules in the Numbers app?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.