You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
Does anyone know how to set up a condition inside a cell that will automatically fill it green or red based on the results of a subtraction formula? For example, if the result is greater than zero, the cell turns green. I want to know what formula to use to set this up. Thanks
ts
iPad Pro 9.7-inch WiFi, Cellular
Hi tomredmond,
Conditional Highlighting is your friend.
Select the cells then Format > Cell > Conditional Highlighting.
Add 2 Rules:
Regards,
Ian.
Hi tomredmond,
Conditional Highlighting is your friend.
Select the cells then Format > Cell > Conditional Highlighting.
Add 2 Rules:
Regards,
Ian.
Ian, This was perfect, very helpful and I learned something useful. Thank you for taking the time to help. Cheers mate.
Tom
Making a cell a certain color based on the results of a formula
