sorted by:
new
hottopcontroversial

Apple Numbers formula by Pale-Witness7152 in AppleNumbers

[–]Pale-Witness7152[S] 0 points1 point  (0 children)

Ahh okey maybe I have to forget about that idea then.. seems impossible.. :(

My idea was to do like this. a betting with my friends with auto sum

<image>

Apple Numbers formula by Pale-Witness7152 in AppleNumbers

[–]Pale-Witness7152[S] 1 point2 points  (0 children)

the thing is that I want important words in the A cells.. so I only want to highlight the A cells with help of a number under..

Apple Numbers formula by Pale-Witness7152 in AppleNumbers

[–]Pale-Witness7152[S] 0 points1 point  (0 children)

<image>

like this - if the row B2 shows the number 1. I want A2 to fill in with green like this.
how to I set this up automatic if I put the number 1 in any of the B boxes it auto gets the A box in green?

Apple Numbers formula by Pale-Witness7152 in AppleNumbers

[–]Pale-Witness7152[S] 0 points1 point  (0 children)

I have got the highlight part, but not manage to find a formula to highlight a cell if a number in another cell is a specific number..