I have a spread sheet in numbers 12.1. I have watched your videos on conditional highlighting and tried the steps you describe with no results. what I am trying to accomplishes: when column B says “check” column G should turn red unless column L has an emoji check symbol in it. Basically this is my home expense sheet. Column B indicates type of payment ie: cash, electronic check, debit, regular check. Column G is the amount and column L is confirmation of the transaction having been completed.
Example. Column B check. Column G $115.00. column L. ✅ can you help? I even tried chat gpt to no avail.
besides wanting to learn the purpose is to remind me that transactions are not completed such as checks not being cashed. It will save time and protection of overdraft checkbook.
—–
Lawrence
Your goal here is to notice when a transaction is not completed. While a red conditional highlight of the amount column cell would do this, it would be complicated to get that working. Conditional highlights react to the value of that cell, not the value of other cells. You can work around that with some additional columns and formulas, but there is no need, as there is an easier way to meet your goal.
Instead, create another column. I'll use H, though you probably have something there already so you'd then need to move things around. In this column you can have an indicator of what is going on. Maybe it is blank when no attention is needed, and displays "NEEDS CONFIRMATION" or perhaps just an "!!" or the emoji character that is two red exclamation points (‼️).
So in H2, you'd have a formula that checks for your condition. Like:
IF ( AND ( B2="check", NOT( L2="✅" ) ) , "!!", "")
So now you can see clearly in column H what needs attention.
I talk about this and have more ideas in this video:
https://macmost.com/mac-numbers-conditional-highlighting-and-alternatives.html