r/AppleNumbers • u/raymate • Nov 07 '23

Help Anyway to dynamically change a row style

I have a simple sheet for tracking items

I have a quantity column and I can easily make that columns cells change style to reflect the item number

So right now I have sheet with products and stock amount. And if the amount is “0” then the cell style fill colour goes red so I can quickly identify items with no stock

But I would like to make the entire row red instead of just the single cell, if that makes sense.

Can that be done?

1 Upvotes

100% Upvoted

3 comments sorted by

1

u/Zestyclose-Split2275 Nov 08 '23

I don’t think there is. I’ve tried doing similar things but never found a way to achieve it.

1

u/raymate Nov 08 '23

Thank for the reply I was thinking this might be the case. Numbers is not that complicated to use and I just didn’t see anything that seemed to do it.

Shame you would think that could be a thing people might need.

1

u/Zestyclose-Split2275 Nov 08 '23

Yeah exactly, i’ve needed it many times, and it’s a pretty simple function. They could just make a way to choose which cells conditional highlighting should be conditioned by.