Conditional formatting based on numbers in columns

  • Thread starter Thread starter Nic Daniels
  • Start date Start date
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!
 
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:
 
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
 
Thank you!




--
Kind regards, Nic


Stefi said:
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:
Click to expand...
 
Thank you!






--
Kind regards, Nic


Mike H said:
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
Click to expand...
 
Back
Top