Conditional formatting based on numbers in columns

[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!

 

[Stefi]

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

Regards,
Stefi

„Nic Daniels†ezt írta:

 

[Mike H]

Hi,

For you first condition apply this to A1 and select Red

=AND(C1>0,C1>D1)

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

=AND(C1>0,C1=D1)

Repeat the above for B1 choosing the appropriate colours.

Mike

 

[Nic Daniels]

Thank you!




--
Kind regards, Nic

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

Regards,
Stefi

„Nic Daniels†ezt írta:

 

[Nic Daniels]

Thank you!






--
Kind regards, Nic

Hi,

For you first condition apply this to A1 and select Red

=AND(C1>0,C1>D1)

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

=AND(C1>0,C1=D1)

Repeat the above for B1 choosing the appropriate colours.

Mike

 

[Stefi]

You are welcome! Thanks for the feedback!
Stefi

„Nic Daniels†ezt írta: