Hi,

For you first condition apply this to A1 and select Red

=AND(C10,C1D1)

Click ADD and apply this second condition to A1 and choose Green

=AND(C10,C1=D1)

Repeat the above for B1 choosing the appropriate colours.

Mike

"Nic Daniels" wrote:

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 C10 AND if C1D1, the background color of cell A1 turns green and B1
turns red.

but If C10 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!


--
Kind regards, Nic