For example, if A1 and A2 are both positive, then I want A3 to be green. Also, if A1 and A2 are both negative, then I want A3 to be green as well.
Is there a way to do this? I'm using excel 2010
You can just use conditional formatting with the following formula:
To do so, select Cell A3, go to the Home tab and select
Yes, you can use conditional formatting with an if statement.
Let me show you how. Please review the image first:
So, the formula in C1 is
which is copied down to C3.
Then, I select the C column and click on the Home tab -> Conditional Formatting -> New Rule.
I select Format only cells that contain
From the first drop down menu, select "No Blanks" then click the Format button. Open the Fill tab and select green (remember what green you select). Then, if you want to remove the text I suggest you open the font tab and change the font colour to the same green.