The Apple Support Community will permanently close on November 20, 2026. Starting today, the site will no longer accept new posts and is available in a read-only state.
You can continue to find trusted guidance and support on the official Apple Support site.
We want to thank the community members who have contributed their time and expertise to help others with their Apple products.
The Apple Support Community will permanently close on November 20, 2026. Starting today, the site will no longer accept new posts and is available in a read-only state.
You can continue to find trusted guidance and support on the official Apple Support site.
We want to thank the community members who have contributed their time and expertise to help others with their Apple products.
I have a sheet with descriptions of items I am logging with multiple checkboxes on the same row who's totals are counted in a cell on the same row, I want the cell with the description cell with the name to change color when a certain amount is reached in the "total" cell.
MacBook Pro 15″, macOS 10.15
In the toolbar's Format / Cell pane, select Conditional Highlighting and set the rules for your colouring.
I may have worded that badly. but I just want a cell background color to change when another cell reaches a certain number
Hi jonpen,
Add another column to test against. You can hide this extra column when all is working.
Formula in H2: IF(G2≥A$1,$A2,"")
Regards,
Ian.
That makes sense, Thank you!
how do I change the background color of a cell with the result of another cell when that cell becomes a certain number?
