Forum Discussion
Conditional formating on sum of 2 cells
Hi. I don't see the answer to my question - I am creating a spreadsheet and want to add 2 cells - eg. A34 (revenue) minus A35 (expenses) and I want A36 to be red if I get a negative number (revenue...
Hi jsiegs
So to get the data you need in A36 use this
=sum(A34-A35)
Then you can apply conditional formatting. To do so, select cell A36, and in the ribbon, select conditional formatting > new rule > Format only cells that contain > Cell value > greater than or equal to >0. Than select Format > Fill tab > pick a color (green in this case)
Repeat for cell value less than "0" with the color red.
That should do.
Ben
