[Numbers] Help! Conditional formatting tips
Hello all, first post not sure how to work Apple Numbers conditional formatting or if this is even possible on this
On Apple Numbers if I have an excel sheet is there any way I can use conditional formatting based on the cells used in a formula?
So let’s say I have Cell A which is the sum of Cell X,Y, & Z, is there any way I can apply a conditional formatting rule to my spreadsheet on any cell used in the formula for Cell A? So in theory would highlight Cell X,Y,& Z since these 3 are used in the formula for Cell A
Thanks for any help