-1

On Google Sheets I put conditional format:

Condition 1: =IF(I2="Shipment (Pickup)",TRUE,FALSE)

then background green, text None (or Black).

Condition 2: =AND(G2<(Now()+(16/24)),I2="Shipment (Pickup)")

then background green, text RED

but it won't change as expected and only show the first condition when satisfied. If I delete the first one then the second one works.

How could I have both of them work?

pnuts
  • 58,317
  • 11
  • 87
  • 139
user1314404
  • 1,253
  • 3
  • 22
  • 51
  • Can you please post your entire code snippet? I believe the problem is the order of your conditions, but it'd help if I could see the entire code. – bartinmader Jan 23 '19 at 08:55

1 Answers1

1

Your code works, it's just in the wrong order.

Make sure your first rule is:

=AND(G2<(Now()+(16/24)),I2="Shipment (Pickup)")

And the second rule is:

=IF(I2="Shipment (Pickup)",TRUE,FALSE)

You can change the order of your conditional formatting rules by clicking on the three dots on the left of the rules and dragging them around.

Here's a link to a Google Spreadsheet which does exactly that.

bartinmader
  • 266
  • 3
  • 10
  • 1
    You are the best ! Thank you ! just add it for some one who doesn't know how to drag: click and hold the three dot on the left of the condition cell. – user1314404 Jan 23 '19 at 09:19
  • 1
    Thanks for the input, I just added this to the answer. – bartinmader Jan 23 '19 at 09:23
  • Hi @badermart : since you are very good on this google sheet, do you think you can have me with this question also: https://stackoverflow.com/questions/54300970/how-to-sum-up-the-values-in-each-column-and-ranking-each-column-name-by-sum-of-v – user1314404 Jan 23 '19 at 09:29