Conditional formatting based on numbers in columns
 

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

Conditional formatting based on numbers in columns
 

Condition formula for Column A:
=AND(C10,C1=D1)
Condition formula1 for Column B:
=AND(C10,C1D1) red
=AND(C10,C1=D1) green

Regards,
Stefi

€žNic Daniels€� ezt Ã*rta:

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

Conditional formatting based on numbers in columns
 

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

Conditional formatting based on numbers in columns
 

Thank you!




--
Kind regards, Nic


"Stefi" wrote:

Condition formula for Column A:
=AND(C10,C1=D1)
Condition formula1 for Column B:
=AND(C10,C1D1) red
=AND(C10,C1=D1) green

Regards,
Stefi

€žNic Daniels€� ezt Ã*rta:

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

Conditional formatting based on numbers in columns
 

Thank you!






--
Kind regards, Nic


"Mike H" wrote:

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

Conditional formatting based on numbers in columns
 

You are welcome! Thanks for the feedback!
Stefi

€žNic Daniels€� ezt Ã*rta:

Thank you!




--
Kind regards, Nic


"Stefi" wrote:

Condition formula for Column A:
=AND(C10,C1=D1)
Condition formula1 for Column B:
=AND(C10,C1D1) red
=AND(C10,C1=D1) green

Regards,
Stefi

€žNic Daniels€� ezt Ã*rta:

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