I would like every cell in column A formatted either Red or Green based on the following logic:
If the corresponding (same row) cell in column B is a 0 then a positive number in Column A should be highlighted/filled Red. If column B is 0 and Column A is negative number then Column A cell should be highlighted/filled Green.
Similarly if Column B is a 1, and Column A is positive, then Column A cell should be Green. If Column B is a 1, and Column A is a negative, then Column A cell should be Red.
See the below table for the logic I'm looking for with color coding.
<tbody>
</tbody>
Thanks in advance for your help.
If the corresponding (same row) cell in column B is a 0 then a positive number in Column A should be highlighted/filled Red. If column B is 0 and Column A is negative number then Column A cell should be highlighted/filled Green.
Similarly if Column B is a 1, and Column A is positive, then Column A cell should be Green. If Column B is a 1, and Column A is a negative, then Column A cell should be Red.
See the below table for the logic I'm looking for with color coding.
1 | 0 |
-1 | 0 |
1 | 1 |
-1 | 1 |
<tbody>
</tbody>
Thanks in advance for your help.