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
