N
Nic Daniels
Hi,
I would like to change the background color of a two cells (row by row)
based on values in two other cells in the same row.
If C1>0 AND if C1>D1, the background color of cell A1 turns green and B1
turns red.
but If C1>0 AND C1=D1, the background colors of both cells, A1 and B1 turn
green.
Ex:
A B C D
1 Green Red 1 0
2 Green Green 12 12
3 No change in background color
Thank you!
I would like to change the background color of a two cells (row by row)
based on values in two other cells in the same row.
If C1>0 AND if C1>D1, the background color of cell A1 turns green and B1
turns red.
but If C1>0 AND C1=D1, the background colors of both cells, A1 and B1 turn
green.
Ex:
A B C D
1 Green Red 1 0
2 Green Green 12 12
3 No change in background color
Thank you!